DamoBird365
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...
Mail Merge with Attachments Power Automate
Do you perform a weekly or monthly mail merge and have a requirement to send your customers a unique attachment like an invoice or personalised letter?...
Parse A CSV to JSON Array in Power Automate Easily & 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...
FormatDateTime and Formatting a String Date in Power Automate
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...
Populate an Excel Template (Invoice) dynamically using Power Automate
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...
SUM a List of numbers in Power Automate
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...
Efficiently parse a CSV File to JSON without an Apply To Each in Power Automate
Off the back of my demo of the Union, Except, Intersept (click here) actions in Power Automate I learn’t something new. How to use the Select...
Union, Except and Intersect performed efficiently in Power Automate
Imagine you have two datasets that you want to compare where you would like to include or exclude common or uncommon rows from each? Out of...
Step by step guide to your first PAD integration with ServiceNow
I wrote a post about this recently and demonstrated how you can use PAD to close down your ServiceNow calls and potentially save yourself some admin...
Error Handling | Power Automate
You have multiple flows, they run multiple times a day and then one starts failing. Power Automate will eventually notify you that your flow has failed...