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? I am going to show you how you can perform this process using Power Automate. If you have a requirement for creating […]

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 easy solution to tackle the common problem. I have a solution for you to consider without using the Premium Connectors. I have […]

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 to compare it against today’s date or a date in the past/future, what options are available to you to manipulate that date? […]

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 offer the same functionality. Via Tables in Excel you can add and update rows in Excel but it can be quite complex […]

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 must use a variable to store the running total of a sum via apply to each using the add expression and an […]

Power Automate | Efficiently parse a CSV File to JSON without an Apply To Each

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 Action. I then began to look at where else I could use this useful action to improve upon efficiency of other processes […]

Power Automate | Efficiently perform Union, Except and Intersect

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 the box, the Power Automate platform allows you to compare datasets with the Union and Intersect expressions. You might require all members […]

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 a few times recently and that you should take a look but how about a proactive approach to error handling? If your […]

Basic House Keeping | Power Automate

It sounds pretty obvious really, you build a solution and you give it a meaningful name or next time you return to your environment you cannot remember what on earth your automatically named flow does or what it was for? I tend to include 3 things in my […]

Experimenting with Azure Cognitive Services

Microsoft give you a 12 month Azure free trial and so I thought I would have a play with some of their Cognitive Services API’s. I setup both the Face and Computer Vision Tools . The Face tool has over 1 Million people matched and has the ability […]