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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Compose action to sort...
Power Automate
Answered

Compose action to sort data from list rows

(0) ShareShare
ReportReport
Posted on by 4

Hi Everybody, Need some help. I am new to power automate and am trying to learn on the go. please correct me if my approach is completely wrong.

I am building a flow that uses a AI model to push data into excel sheet on one drive. I would like to sort this data and push only the data from the current run to sql, using a column that captures email receipt time to do that. After 'add a row into a table' action, i am am using a 'list rows present in a table' action and then compose to sort that data. I see no issues upto list rows (outputs looks good) but my compose does not sort the data and shows the same output as input expression. I tried a multiple expressions example: sort(body('List_rows'), 'Email_time', descending), nothing works. TIA!!

rookie_40_0-1710188516067.png

rookie_40_1-1710188635964.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    The contents of the Compose action should go inside the expressions window

     

    Just enter this:

    SudeepGhatakNZ_1-1710192323015.png

     

     

  • rookie_40 Profile Picture
    4 on at

    Thank you, it works.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard