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...
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...
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...
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...
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...
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...
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...