Finding Records Shared With a Specific Team or User
I needed to find all Accounts that were shared with a specific Team so the permissions could be amended. This isn't possible with Advanced, Find, but a simple FetchXML tweak will make…
Ryan Maclean
54
Posts
11,416
Views
Calculate Full Months between two dates with Power Automate
My friend Antti Pajunen recently asked me whether it is possible to calculate the number of months between two dates with Power Automate, akin to the DateDif function in Excel. I like…
Converting UTC Date Time to UNIX Time with Power Automate
Recently Ben Vollmer asked if it was possible to convert a UTC datetime value to Unix time in Power Automate. There’s no function available out of the box to do this, but…
Converting Excel Date Time Serial Values With Power Automate
A common issue I’ve run into and that I’ve heard others experience, is trying to use Excel DateTime values in Power Automate. You will encounter an error like below: The reason this…
Calculate Quarter for a Date in Power Automate
A common request in my company is for dates to be expressed in relation to the Quarter of the year in which they fall. Using Power Automate there is no native way…
Change a User’s Business Unit and retain their Security Roles using Power Automate
I saw a tweet recently from Linn Zaw Win asking if it was possible to change a Users Business Unit without losing their Security Roles If you’ve been following my blog you…
Calculating ISO 8601 Week Number for Dates in Power Automate
Power Automate doesn't support the calculation of the ISO week number of a given date out of the box. With this simple expression you can find out the ISO 8601 week number…
Dynamics 365 Opportunity Revenue Forecasting with Power Automate – Part 1
A common complaint I hear about Opportunity pipeline management in Dynamics 365 is that it's difficult to use for revenue/income forecasting, as the system considers that you will receive the whole Estimated…
Selecting a specific SharePoint Document Library to Upload Dynamics 365 Email Attachments using Teams Adaptive Cards
In my recent series of posts I covered how to implement a better integration between Dynamics 365 and SharePoint. One of the common scenarios that you will encounter if you’ve integrated the…
Synchronising Azure Active Directory Security Groups between D365 Records and SharePoint Sites
In my previous post I discussed how to synchronise permissions between D365 Access Teams and a related SharePoint site. This works really well if you have a system…