I would go about this differently. I'd concatenate the Calculated Columns in the order I want, then sort the combined values in descending order.
For this example, I've got the following SharePoint List where Amount is a Number column, and Age, Item_Status, and Auto_Status are Calculated columns.
See full flow below. I'll go into each of the actions.
Get items retrieves the items from the SharePoint list.
Select maps out the columns we want to use, and an additional column called Order that will combine our Calculated columns plus the Amount column. The expression used for Order is below.
concat(
item()?['Item_Status'],
'|',
item()?['Auto_Status'],
'|',
item()?['Age'],
'|',
item()?['Amount']
)
Select Sorted uses the output from Select sorted in reverse order. The expressions used are below.
//From
reverse(sort(body('Select'), 'Order'))
//Map
item()?['Title']
item()?['Item_Status']
item()?['Auto_Status']
item()?['Age']
item()?['Amount']
After running the flow, Select Sorted would include all the values sorted in descending order.
[
{
"Title": "Item 0003",
"Item_Status": "Young",
"Auto_Status": "Low",
"Age": "11.0000000000000",
"Amount": 6
},
{
"Title": "Item 0001",
"Item_Status": "Old",
"Auto_Status": "Medium",
"Age": "49.0000000000000",
"Amount": 51
},
{
"Title": "Item 0004",
"Item_Status": "Old",
"Auto_Status": "High",
"Age": "50.0000000000000",
"Amount": 110
},
{
"Title": "Item 0002",
"Item_Status": "Middle",
"Auto_Status": "Medium",
"Age": "24.0000000000000",
"Amount": 25
}
]
