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…

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…

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…