Power Automate

Adding a decimal count to your Power Automate Flow (Float/Increment variable)

I’ve explained how to count in a variable, but how do you count in a decimal? I had a usecase, where we wanted to create a version number metadata field. We could of course use an integer, count using increment, and upload to the field, however that only does ‘major’ counts i.e 1.0 to 2.0 to 3.0 etc. How do I count in minor, decimals, from 0.1 to 0.2 to 03 or even 0.01 to 0.02? To do this, you can follow the same logic, but use a float value instead of integer.

Monday, November 4, 2024 | 1 minute Read

Calling a Power Automate Cloud flow, from Power Pages forms (!) using Javascript

Calling a Power Automate flow from a dataverse form, in a Power Page form Sounds easy right? Trust me it’s not, but I hope this helps. I have had tremendous help from my colleague Laurens Hoogendoorn, who is completely awesome and helps me run with javascript (see what I did there) before learning how to crawl or walk. LOL. Laurens, you are the best! So, let me start at the beginning.

Wednesday, July 17, 2024 | 4 minutes Read

How to use regex in Power Automate Cloud flows

I had a client scenario, where I needed to grab a 6-digit number from an incoming email subject. It wont always be in the same place, and also possibly not be the only digits. So I couldnt use trim, length or other that I could think off. Unfortunately, or luckily, depending on how you look at it, my dear friend Cat Schneider introduced me to regex Thankfully someone within my company helped me guide a regex expression I could use, but I do want to share this awesome resource:

Thursday, July 11, 2024 | 1 minute Read

Dynamic content not displaying my action

I came across this today and wanted to share. I couldnt figure out why my output from the teams adaptive card was not an option to select in my Compose (no body or anything available). 😭 Scenario: You have an action in your flow, for example a teams adaptive card, and want to use the output somewhere. Whether thats in a compose, set variable, update row, doesnt matter. What you try and do, it wont show.

Thursday, June 8, 2023 | 1 minute Read

Another quick tip! Removing blank items in a compose

This is a follow-up post for my earlier blog, Combine data from multiple apply to each into a single output file (Variables and compose) Cat Schneider helped me tremendously on this one, full credit to her! Find her blog here Following these steps, results in some empty values also being added. For example, if there is an empty entry, but the item exists and you specify that item it will show up.

Wednesday, March 29, 2023 | 2 minutes Read

How to get submitted values from your Choices/optionset column in Dataverse

Ever noticed that when you select your columnname, in the dynamic data, it doesnt give you the result and it stays blank? I’d like to explain how you can get the value for your dropdown. There is a difference between the display name, and the actual name of that value. Dataverse often uses @OData.Community.Display.V1.FormattedValue instead of the previous new_value_label. In your Power automate flow, either run the flow and check the body, or add a Compose step after your Get Items/Update Item etc. step for Dataverse.

Power Automate

Tuesday, March 7, 2023 | 2 minutes Read

Adding a count to your Power Automate Flow (Integer/Increment variable)

Starting with an intro to variables, I want to explain how you can use a very simple counter to your Power Automate flow. Let’s say you have an Apply to each, like 5 entries, and after this you email your client with the combined data from those 5 entries. Add the following steps: On top of your flow, add an Initialize Variable Choose a name Select Type Integer Leave Initial value blank (or select a starting count) In your Apply to each, add an Increment Variable (Increment means to add/change the count) Increment the variable you’ve created on top with 1 in the value. Add the variable after your Apply to each step wherever you want, and it will give you the count.

Tuesday, January 3, 2023 | 1 minute Read

Combine data from multiple apply to each into a single output file (Variables and compose)

This was a tricky one to figure out, took me a few hours and failed attempts. I have log entries, and my flow is triggered to email them all that were submitted the day prior, at 8am. Getting the data into the email pulls it into an apply to each (which makes sense, but is not what I want) So, there is a way around the apply to each, but I’ll not get into that here.

Tuesday, January 3, 2023 | 1 minute Read