Category: Flow
-
Power Automate – Excel Dynamic Filename
In the Excel connector we are forced to use the file picker (folder icon) to select a Excel file. But what if we did not know the filename,…
-
Grab Azure Key Vault Secrets Securely
Using Azure Key Vault to pass in secrets into Flow for secure transportation of sensitive information
-
Power Automate Expression Union – Return Unique Values
Power Automate Expressions – union Using union to remove duplicates on two different collection arrays
-
Power Automate Tips and Tricks for Beginners
In this post, I wanted to share some of the tips and tricks that I have learnt and came across. Some of these tips I will cover the…
-
Adding Security Roles and Field Security Profiles to Users in CDS using Power Automate
The Scenario We will be adding a Security Role / Field Security Profile to users in CDS. For this demo, our scenario will be grabbing all the users…
-
Throw an Exception Easily (Error)
Basically, we want to be able to control if we want an error. At this time Flow does not let you easily throw an error. There is a…
-
Authentication on Microsoft Forms
Microsoft Forms is great for many use cases. However, with some use cases you may not want the whole organization to have access to this form. Summary In…
-
Bypass Apply to each Loop
Have you ever noticed that Power Automate will sneak in that ‘Apply to each loop’ even though you are only expecting a single value. For example this can…
-
Excel Filtering on Columns With a Space
Using the Filter or the Select Query in Excel is very easy to use. However the issues come up when there is a space in the column you…