web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sort By dataverse output
Power Automate
Unanswered

Sort By dataverse output

(0) ShareShare
ReportReport
Posted on by 74

All,

 

I'm needing assistance with sorting my List Rows data output from Dataverse. I'm able to sort it using exterior actions, like compose and others, but what I really need is to Loop on the data based on the already sorted data. Example, Record0001, Record0099, Record0023 are all out of order when they come in, I need them to be Record0001, Record0023, Record0099; I have conditionals that get this record number, set a variable using that number, then compare that variable to the next record number in the List Rows output in order to see if duplicates are occurring, if duplicates are gt or eq to 5, then write the data to an Excel Online file. If they run out of order on the record number, it will never satisfy the condition, and always be false. If anyone needs any additional information let me know and I'll do my best to provide it. Thank you.

smw356239_0-1684247160108.png

 

 

Categories:
I have the same question (0)
  • Linn Zaw Win Profile Picture
    2,996 on at

    You need to specify the Sort By in your List rows action. If you are querying by FetchXML, you need to add the <order> element.

     

    LinnZawWin_0-1684848917365.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard