SharePoint Cloud Hybrid Search Tips

I recently set up SharePoint 2016 hybrid in a lab environment for customer demos. I thought I would post some quick tips/tricks, specifically for Cloud Hybrid Search based on what I learnt during the configuration –   Delete your existing on-prem SSA if you have one configured already. The Cloud SSA which you provision as part…

Flow – Get SharePoint list items by the current date using ODATA

The built in Flow ‘Get Items’ and ‘Get Files (Properties Only)’ actions are great for retrieving a filtered set of items from SharePoint lists and libraries using an ODATA query except when it comes to working with dates! Sometimes you may wish to query list items/files based on the today’s date e.g. Created, Modified or…

SQL instance connection error – ‘A network-related or instance-specific error occurred’

I was stumped with this error for hours last night while building out some on-premises SharePoint Farms. I was trying to connect to a specific named instance as opposed to the default instance.  I thought I would blog about the fix because it’s something I’ve never come across before and it took some googling of…

Publishing page rollup approval using Microsoft Flow

One of our clients had a requirement to approve pages created by users within their Intranet in order to have them displayed on the home page. In this particular case we’re using a classic SharePoint publishing site with a custom search based rollup Web Part from Intelligent Decisioning’s Mercury Intranet product. We didn’t want to…