If you work with PDF files in Power Automate, you will already know that even simple PDF tasks can become awkward surprisingly quickly. Things like splitting a PDF, extracting text, merging files together, or pulling out a specific range of pages often end up needing premium third-party connectors, complicated workarounds,…

Continue Reading Free PDF Tools for Power Automate now available!

Back in 2021, I wrote a popular article showing how to batch create items in SharePoint using Power Automate. Since then, the chunk() expression has been introduced which makes batching far simpler. In this post, I will show you how it works on a CSV file of 15,000 rows. This…

Continue Reading Power Automate: The Simplest Way to Batch Create SharePoint List Items

Zip File Support in Power Automate is fairly limited. There are actions to extract files from an archive, but no support for creating your own zip files. I’ve written before about a method to create Zip files in Power Automate for free using SharePoint. The SharePoint method described worked, but…

Continue Reading Working with Zip Files in Power Automate

When using the SharePoint Update Item action in Microsoft Power Automate it forces you to enter values for mandatory columns. For lists with many columns this can be a long process if you only want to update a few fields. Example: This list item contains a number of fields: Field…

Continue Reading Easily update fields in a SharePoint list with Power Automate

This post describes how to merge two separate arrays that contain a common value. My friend Tom Riha recently wrote a good post on how to do this. His method will work well for a small dataset, but for a large array it would be quite time consuming as it…

Continue Reading How to merge arrays in Power Automate

This post explains how to sort an array of objects in Power Automate. This method only works for objects that contain a numeric value on which to sort. I have done a previous post on How to Sort an Array in Power Automate using Office Scripts, which works very well,…

Continue Reading Sort an Array of Objects with Power Automate

In this post I will show you a Power Automate Flow you can use to add days to a given date and exclude weekends, or specific dates from the result. I was inspired to do my own solution by some recent posts by others: Tom Riha – How to add…

Continue Reading Add working days to a date in a Power Automate Flow

If you need to bulk delete data from a Dataverse table it is easy to setup a Bulk Record Deletion job from the Dynamics 365 Data Management portal. But if you are using Dataverse for Teams, there is no access to the portal. In this post I am going to…

Continue Reading How to Bulk Delete Records from Dataverse with Power Automate

In this post I will show you how to export data from Power Automate, to an Excel file. This would seem to be a straightforward requirement, but until recently has required the use of apply to each loops which are slow and can potentially use many API actions. Table of…

Continue Reading How to export data in Power Automate to an Excel File

In this post, I will explain how to create a Zip file in Power Automate without the use of any third party connectors or premium actions. https://youtu.be/FCXjpRYo9T8 Table of contentsIntroductionFlow DetailFlow Code and ImplementationAdditional InformationUpdate December 2024Conclusion New Zip File Creation Method Available! I’ve developed a new, low-cost method to…

Continue Reading How to create a Zip file in Power Automate for free