cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GaneshDRajan
New Member

How to sort excel based on column using power desktop automate?

How to sort excel based on column using power desktop automate?.. Wanna sort based on the data column in a descending order.

3 REPLIES 3
fraenK
Memorable Member
Memorable Member

Just apply a table format to your Excel data and Excel will sort it for you.

Otherwise you would need to read all data into PAD, get the column you want to sort as list, remember original row numbers, sort list and reorganize the other columns based on the original and new row numbers.

Can you share me the flow screenshot for this?. Bcz I'm new to this tool.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,515)