Sort Array in Power Automate
Power Automate
Oct 10, 2022 12:00 AM

Sort Array in Power Automate

by HubSite 365 about Dhruvin Shah [MVP]

Microsoft MVP (Business Application & Data Platform) | Microsoft Certified Trainer (MCT) | Microsoft SharePoint & Power Platform Practice Lead | Power BI Specialist | Blogger | YouTuber | Trainer

Citizen DeveloperPower AutomateLearning Selection

Today Let's talk about how to sort array in Power Automate. To sort array in Power Automate we need to use e...

In this video, Dhruvin talks about how to sort arrays in Power Automate. The Sort-function is needed to sort an array in Power Automate. By default, it sorts in Ascending order. To reverse the order, the Reverse-function can be used.


Further info around sorting in PowerAutomate

Power Automate – How to sort an array

For an alternative way to sort an array, this post can be helpful. It shows how to sort with an Office Script.

https://www.tachytelic.net/2021/03/power-automate-sort-array/

Sort an array in Power Automate in 3 easy steps

Pieter Veenstra explained how to sort arrays in Power Automate using an Azure function. However, this requires a premium license. Therefore, he also explains how to do it in 3 easy steps with Excel in Power Automate:

https://sharepains.com/2020/03/05/sort-an-array-in-power-automate/

Sort Array in Power Automate, Using Custom Code Connector

Another alternative to sort arrrays in Power Automate is building a custom code connector as shown here:https://steelcutbytes.com/2021/10/09/sort-array-in-power-automate-using-custom-code-connector/