103
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
Just sort 2 times (and reverse the sort results):
Share
Report
All responses (
Answers (
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
}
]
