You know the logic, if a logical expression is met, perform an action or expression, else if it matches another expression follow that outcome, otherwise do the fall back option. How do you create this in Power Automate? Well, you could use the switch action...
Continue reading...Power Automate
One to one relationship between data in Flow
You’ve retrieved relational data from non relational datasources and you want to create a relationship for your Power Automate. In my example below I have used tables in Excel and a List in SharePoint where the records share a common primary unique ID and then...
Continue reading...Parse A CSV To JSON Array Quickly
It’s an age-old problem, you have a CSV file that you want to parse into a JSON Array and you want a single quick and easy solution to tackle the common problem. I have a solution for you to consider without using the Premium Connectors....
Continue reading...FormatDateTime and Formatting a String Date
You’ve got a date for your Power Automate from a source whether that be a list item, dataverse entity attribute or other source and you want to compare it against today’s date or a date in the past/future, what options are available to you to...
Continue reading...Perfectly complete an Excel Invoice Template
You will have probably used the Populate a Microsoft Word Template (Premium) action in Power Automate before but will be saddened to learn that Excel doesn’t offer the same functionality. Via Tables in Excel you can add and update rows in Excel but it can...
Continue reading...Want to SUM up a List of numbers?
It might suprise you to hear that there is not a SUM function in Power Automate, if you wish to add a list of numbers you must use a variable to store the running total of a sum via apply to each using the add...
Continue reading...Magic Efficient – CSV to JSON
Looking to convert a CSV to JSON in Power Automate and do this efficiently? You’re in luck. This is by far the best method without using an Apply to Each!
Continue reading...Efficient Union, Except And Intersect – Great Method
Looking to join arrays in Power Automate. No Except or Left Outer Join Method. Let me show you how you do it.
Continue reading...Microsoft Forms to PDF – No Premium Actions
Let me show you how to convert you Microsoft Forms response to a PDF using Power Automate, all without premium actions!
Continue reading...