Latest from the Blog
- Power Automate – Format Phone Number Easy
Take a phone number like 4031234567 and turn it to (403)-123-4567 with one simple step! - 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, or we are expecting NEW Excel files.. We will need a dynamic 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 basic fundamentals so you can start using them to help you build you Flows with less pain and more fun! 1. Compose Compose actions, are one of … Continue reading “Power Automate Tips and Tricks for Beginners” - 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 from a Office365 group and assigning them a certain Security Role / Field Security Profile. The source of the users can be from anywhere:– MS Form– SharePoint– … Continue reading “Adding Security Roles and Field Security Profiles to Users in CDS using Power Automate” - 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 Terminate action which is awesome, I use it in every Flow or Logic App I create.The Terminate Action will terminate the Run immediately. Terminate will not allow … Continue reading “Throw an Exception Easily (Error)” - 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 short, we want to setup a way to allow certain users to fill out a MS form.How can we achieve this?My Flow below will show how to … Continue reading “Authentication on Microsoft Forms” - 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 happen whenever you are using a Action that ‘Lists’ items, folders, fields, etc. In this example I will be showing how to get a User ID in CDS with the users Full Name. - Excel Filtering on Columns With a SpaceUsing 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 are trying to Query, which results in a Bad Request error.
