web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Sort function in a com...

Power Automate

Answered

Sort function in a compose action

(0) Share

Report

Report

Posted on by Zotmani

33

Hi Community,

I hope you're doing well!

I'm encountering an issue with sorting data in my Power Automate flow and could use your help.

My Situation:

I have a Compose action named "Compose_11" with the following output format:

I need to sort this data based on the OffreApresRectif field in ascending order.

What I've Tried:

I created another Compose action with the expression:

sort(outputs('Compose_11'), 'OffreApresRectif')

The inputs of this compose action are :

And the outputs are :

This doesn't sort correctly because the OffreApresRectif field contains strings, where numbers are alphabetized. I tried converting them to integers but wasn't successful.

Could you please help me fix this issue and achieve the desired sorting?

Thank you in advance for your assistance!

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SamLed 2,340 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Zotmani,

Select all properties as string, add again the one you want to convert and convert its value using int() function, then sort Select output by that converted value, finally Select all string properties from sorted output.

See current flow design to illustrate:

Results:

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
Zotmani 33 on at

Like
a
(0)

Report
Copy link

Link copied!

@SamLed Thank you very much, you saved my life, your method is working 🤓

Join the conversation