Unanswered

Sorting (ordering) arrays

(0) Share

Report

Posted on by PWrobel Microsoft Employee

Hi! I'm building an array dynamically in flow and would like to order (sort) the data in the array. How can I acheive it?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

PieterVeenstra 13 on at

Like (0)

Report

Hi @PWrobel ,

This is the easiest approach, using an azure function:

https://veenstra.me.uk/2019/07/13/sort-an-array-or-collection-in-microsoft-flow/

Was this reply helpful? Yes No
PWrobel Microsoft Employee on at

Like (1)

Report

Thanks Pieter. To bad there is nothing out of the box that does not require access to Azure subscription.

Was this reply helpful? Yes No
Verified answer

ilu989 164 on at

Like (0)

Report

Hi @PWrobel ,

I have the same issue but find two websites for me to solve it, it might help you to achieve your requirement:
http://johnliu.net/blog/2018/12/how-to-implement-sort-with-microsoft-flow-in-3-actions-within-a-loop

The answer from "v-bacao-msft"
https://powerusers.microsoft.com/t5/Building-Flows/Create-Update-Sharepoint-List-using-an-Excel-List-using-Flow/td-p/297835

Good luck!
ilu989

Was this reply helpful? Yes No
PWrobel Microsoft Employee on at

Like (0)

Report

Thanks Ilu

I was thinking about building my own sort function in loop, so now I can just copy it 🙂

Was this reply helpful? Yes No
Mx81 860 on at

Like (1)

Report

If you need a build-in function, please vote for this idea:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Sort-Array/idc-p/486807#

Was this reply helpful? Yes No
somefloridaguy 5 on at

Like (1)

Report

TRY THIS EXPRESSION (as an Expression for a Compose Action in Flow):

(Assume that "my_array" is the array of POSITIVE INTEGERS that you want to sort.)

Expression (For Ascending Sorting):
intersection(range(min(my_array),max(my_array)), my_array)

Note: It only works on Positive Integers, but it does NOT require having to create any new Variables or "Apply to each" action loops.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

I like the solution by @Paulie78 (https://www.tachytelic.net/2022/07/power-automate-sort-json-array/), it's more universal as it can handle objects and decimal numbers as well.

Was this reply helpful? Yes No
Mx81 860 on at

Like (3)

Report

Finally: there is a sort() expression available.
And with reverse() you can also do descending sorting.

By the way: I cannot find the ideas section anymore... 😞

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (3)

Report

I did a video on the new expressions:

How to sort arrays in Power Automate.

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
JerryFr83560 19 on at

Like (0)

Report

I can't find this.

Was this reply helpful? Yes No