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 […]

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 time. I was then asked if I could do a video on how I built the solution. So, below you will find […]

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 […]

PowerShell Get List of Members from O365

Quite a short post really. Have you ever needed or wanted to get a list of members for an O365 Group? Then I have a simple PowerShell for that. Use the Get-UnifiedGroup CMDLet and if your sites are prefixed like mine, filter on the DisplayName. The above script […]

Power Automate meets PowerShell in Azure

I never knew how this worked or that it even existed until I attended the Global Automation Bootcamp today and saw demos by both Ben Stegink and Jaap Brasser who gave me the confidence to try building a PowerShell Azure Runbook which can be called from Power Automate […]

Changes to Stream Storage Location

Change is on the way to the Storage Location of your Stream recordings. Historically these would be available via the Stream portal but for some and soon for all, Stream recordings will be diverted to OneDrive for Business. Details of which are here. If this happens to affect […]

Microsoft Forms to PDF without Premium Actions in Power Automate

How to populate a word template using data from Microsoft Forms. No need for the Premium Word Template action as this uses a Power Automate and SharePoint Document Library Trick. Does your line of work require you to populate the same template over and over again? Maybe it’s […]