Sorting Array Data Descending and Ascending with multiple columns in Power Automate

(1) Share

Report

Posted on by naidu1811

109

Sort an array by Score in descending order and then by ResponseTimeInSec in ascending order using Power Automate.

Example Input Array Data
Score ResponseTimeInSec

1000 12
2000 8
2000 20
Expected Output
After applying the sorting, your output should look like this:

Score ResponseTimeInSec

2000 8
2000 20
1000 12

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Chriddle 8,441 Super User 2025 Season 2 on at

Like (1)

Report
Just sort 2 times (and reverse the sort results):

reverse( sort( reverse( sort( json( concat( '[', '{"Title": "Item 0", "Score": 2001, "RTime": 12},', '{"Title": "Item 1", "Score": 2000, "RTime": 11},', '{"Title": "Item 2", "Score": 2001, "RTime": 10},', '{"Title": "Item 3", "Score": 2000, "RTime": 9},', '{"Title": "Item 4", "Score": 2001, "RTime": 8},', '{"Title": "Item 5", "Score": 2000, "RTime": 7},', '{"Title": "Item 5", "Score": 2001, "RTime": 6}', ']' ) ), 'RTime' ) ), 'Score' ) )

Result:

[ { "Title": "Item 5", "Score": 2001, "RTime": 6 }, { "Title": "Item 4", "Score": 2001, "RTime": 8 }, { "Title": "Item 2", "Score": 2001, "RTime": 10 }, { "Title": "Item 0", "Score": 2001, "RTime": 12 }, { "Title": "Item 5", "Score": 2000, "RTime": 7 }, { "Title": "Item 3", "Score": 2000, "RTime": 9 }, { "Title": "Item 1", "Score": 2000, "RTime": 11 } ]

Was this reply helpful? Yes No
naidu1811 109 on at

Like (0)

Report

Thankyou @Chriddle

Was this reply helpful? Yes No
Suggested answer

SteveFeldman 77 on at

Like (0)

Report

naidu1811 @Chriddle I have found the sort function to be unreliable when embedding them in this manner. PAuto does not maintain the integrity of the original row order. Therefore i use the following technique. I add a new column in the array concatenating the fields:

{ "itemKey" : concat( column1Name, '|', column2Name, '|', column3Name }

In addition to eliminating the issue I was facing , sorting once usually saves time over multiple embedded sorts. You can also use formation to build in reverse sorts into the key:

sort(

json(

concat(

'[',

' {"itemKey" : "',concat(formatNumber(Score,'0000'),'|',formatNumber(sub(100, RTime),'000')), '|"Title": "Item 0", "Score": 2001, "RTime": 12}]'

etc.

)

),

'itemKey'

)

Was this reply helpful? Yes No