PowerApps – Creating and assigning CDS Security Roles

I’ve been working with the Common Data Service (CDS) recently while developing a few PowerApps and wanted to share my learnings with Security Roles. This was my first time using CDS so there was a bit of a learning curve but what I can say so far is that it’s awesome and incredibly powerful!  I’m…

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…

Flow – Send an email action ‘Out of call volume quota’

I’m currently working on a document disposition/review Flow for a client (more on that coming soon!) which kept erroring. It was specifically failing in a ‘Do Until’ action and sadly Flow doesn’t give you any details as to what failed inside a Do Until.  Inside the Do Until, I had a send an email action…

Office 365 Security & Compliance Admin Center not appearing

I recently asked a client to add us to the ‘Compliance Administrator’ role in the Security & Compliance center of their tenancy so I could set up some Labels and Retention policies for them. What we found is when granted the ‘Compliance Administrator’ or even the ‘Organization Management’ role (which should give a greater level…

Azure password-less sign-in ‘Something went wrong’ error

I recently enabled password-less authentication for our Azure tenant. A number of our staff already used the Authenticator app for MFA sign-in so it made sense to make the move to password-less!  If you’re thinking of enabling it – I can confirm – it’s brilliant! but keep in mind it’s still in public preview.However I…

Flow – Terminate action with custom status

The ‘Terminate’ action provides a useful way to stop/end a flow and specify your own message. One thing to be aware of is that custom ‘Status’ values are not yet supported. In the flow designer the option to enter a custom value is visible for the action, however if you attempt to use it you…

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…