I recently wrote a blog post that showed how to sort an array in Power Automate using Office scripts. That script works well for simple arrays, but it is unable to sort an array of objects. Using the following array as an example: There … [Continue reading] about How to sort an array of objects with Power Automate
Unfortunately, Power Automate does not have any support for Regular Expressions (regex or regExp), which can sometimes be very limiting, or make things which would be easy, quite complicated. Regular expressions are very useful for extracting … [Continue reading] about How to use Regex in Power Automate
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