Deploying Power Automate Flows can be a headache if you have to manually change values inside the Flow for each environment. You also run the risk of missing a value.
When a Flow fails, sometimes we want to capture and send that message out, to a user, support team, or teams channel. In this demo we will go through the steps to capture any error messages from a failed run.
Expressions can be confusing when starting out in Power Automate. Luckily the product team makes things easier each day. I will be showing how to grab an email address Josh.Cook@flowaltdelete.ca and transforming it to Josh Cook
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.
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”
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)”
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”
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.
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 are trying to Query, which results in a Bad Request error.
Deploying Power Automate Flows can be a headache if you have to manually change values inside the Flow for each environment. You also run the risk of missing a value.
When a Flow fails, sometimes we want to capture and send that message out, to a user, support team, or teams channel. In this demo we will go through the steps to capture any error messages from a failed run.
Remember Virus Total? Now you can integrate it with Power Automate to give real time URL and file analysis.
Expressions can be confusing when starting out in Power Automate. Luckily the product team makes things easier each day. I will be showing how to grab an email address Josh.Cook@flowaltdelete.ca and transforming it to Josh Cook
Take a phone number like 4031234567 and turn it to (403)-123-4567 with one simple step!
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.
Using Azure Key Vault to pass in secrets into Flow for secure transportation of sensitive information
Power Automate Expressions – union Using union to remove duplicates on two different collection arrays
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”
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”
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)”
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”
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.