There is no built in function in Power Automate to enable you to sort an array easily. But as with my previous post in which I demonstrated how to sum an array of numbers, this can be achieved very easily with an Office Script. There is quite a … [Continue reading] about Power Automate – How to sort an array
Although it sounds like a very simple thing to do, summing an array of numbers in Power Automate can be quite difficult if you have a large list of numbers to sum. The most common method is to use an "apply each" action to loop round an array … [Continue reading] about How to Sum an Array of Numbers in Power Automate
This post explains how to update a Hyperlink Column in SharePoint Online using Power Automate. Unlike most field types, the hyperlink column has two components, the link address and the alternative text: But when you try to create or update an … [Continue reading] about Update a Hyperlink Column in SharePoint with Power Automate
I recently discovered QuickChart and it is a fabulous tool for generating charts. It's really easy to use from both PowerApps and Power Automate. In this post I am going to explain how to use it to generate charts with Power Automate using data from … [Continue reading] about How to generate a chart with Power Automate
There are no built in actions in Power Automate to Parse a CSV File. There are external connectors which can do this for you, but this blog post will cover how to Parse a CSV in Power Automate without the use of any external connectors. The aim is to … [Continue reading] about Power Automate: How to parse a CSV File to create a JSON array