Using sort function to sort complex Compose action outputs

(0) Share

Report

Posted on by Zotmani

Hi Community,

I hope you’re doing very well.

I need your help to solve a problem.

This is the output of a Compose action in my flow:

My goal is to sort these objects by the sum of TF and TC, such that the one with the smallest sum is the first and so on.

This is the Append to Array action that fills the Compose block:

Before, in a different Compose action, I was able to achieve this using Select block, but in a different context. I’m not sure if I can do it again with multiple data:

Thank you very much for your help and support.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
My goal is to sort these objects by the sum of TF and TC

You would have to isolate these out, into separate array attributes, unless you want to do some elaborate string math. Don't you need those values later on anyway?

Once they are separate fields the rest should be straightforward.

5 Ways to Sort an Array in Power Automate - Power Tech Tips

Was this reply helpful? Yes No
devtollon 24 on at

Like (0)

Report
Copy link

Link copied!

You can't do out-of-the-box because in your array everything is a string (and you can't do math on a string).

First of all, you need extract the numeric values you want to sum and convert them as integers (if you want to be a little "rough" you can split the string on the middle dash, split it again on the colon and take the last value or you can create a regular expression and retrieve the values you need which is definitely a better and smarter solution).

Once you have the integer values, you can sum them and make all the sorting logic you need.

Let me know if this solved your issue!

Was this reply helpful? Yes No
Matthy79 4,182 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I don’t understand what you are doing.

Why do you have an append to array?

Why don’t you add a sort column if you do it that way?

Can you show your flow?

Was this reply helpful? Yes No