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 / Reverse the Table Valu...
Power Automate
Answered

Reverse the Table Values from Excel Read Worksheet Action

(1) ShareShare
ReportReport
Posted on by 10

Hello, 

I have a very simple Power Automate Desktop Flow, that reads an Excel Table and uses For Each loop to display data one row at a time. I would like to see them in a reverse order. I tried to use Reverse List action on the ExcelData but it did not work. Can you please help?

 

Here is my table.

cricrazy05_0-1701874035950.png

 

 

And here is my Flow with Output. 

cricrazy05_0-1701873821268.png

 

Thanks. 

I have the same question (0)
  • Verified answer
    Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    You would need to use Retrieve data table column into list first to have it as a list variable, because Read from Excel worksheet will create a data table by default when you read a range, and Reverse list won't work on data tables. If you retrieve it into a list, you can then use Reverse list to reverse it.

     

    Alternatively, instead of using For each loop, use a simple Loop action and iterate from %ExcelData.RowsCount-1% to 0 by incrementing %LoopIndex% by -1 on each iteration. You can then get your variable as %ExcelData[LoopIndex]%.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • cricrazy05 Profile Picture
    10 on at

    @Agnius Awesome. I changed to regular Loop. I can get the looping work, but how can I display the individual item value for each pass (e.g. 5, 0.0261, then 4,..., 3,... etc)? Sorry, I am pretty new to the PA. 

     

    cricrazy05_0-1701874788316.png

     

  • cricrazy05 Profile Picture
    10 on at

    @Agnius , sorry, I did not realize that you had already showed that. It is working now. Here is my final Loop. 

    Accepted your reply as Solution. Thank you so much for a very quick response. 

     

    cricrazy05_1-1701875075332.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

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 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard