Power Automate

Blog, Power Automate

Match contacts and accounts by email domain with Power Automate

How to extract domain information from email addresses and use it to improve data quality in your CRM database via automatic matching rules.

Blog, Governance, Power Automate

Listing all solution and non-solution flows in a tenant

Analyzing flows with flows has been an interesting endeavor for me lately. Like my previous post on listing SharePoint connectors used in flows, this blog…

Blog, Governance, Power Automate

Listing all SharePoint sites and lists used in cloud flows

While doing an interesting tenant-to-tenant migration as part of a governance case, my colleague Jukka and I we ran into a requirement to list all…

AI Builder, Blog, Power Automate

Work shift automation with AI Builder

Shift work Many organizations, thanks to the specifics of their business, require their employees to work outside the traditional 9h to 17h – Mon to…

Blog, Power Automate

How to use Azure Elastic Jobs to deal with long-running SQL Stored Procedures triggered from Logic Apps or Power Automate

SQL Server connector in Power Automate & Logic Apps has 110 second timeout for queries. You can get around this limit via Azure Elastic Jobs.

Blog, Governance, Power Automate, Power BI

Listing a maker’s apps and flows from the CoE Starter Kit’s Power BI dataset with Power Automate

I bet you’re reading the pretty mouthful topic of this blog post and wondering “what the heck is this about”. You might also be wondering…

Blog, Power Automate

Flow, Dataverse and upsert

Let’s continue with the hidden gem of flow theme. That is, the features of cloud flow that you may not be aware of. This time…

Blog, Power Automate, Power BI

How to use Power BI Activity Events Rest API with Power Automate

If you are a Power BI admin, you probably have had one (or several) occasions when you needed to know what is happening in your…

Blog, Power Automate

FetchXML – The hidden gem of Flow

Have you ever wondered what this mysterious FetchXML Query feature of Dataversen List rows is? If you come from the world of Dynamics 365, you are probably familiar with…

Blog, Power Automate

SharePoint list and calculating sums with flow

Few years ago, I wrote about a Power App, which allows employees to indicate which days they are coming to the office. The solution is used in…