How to sort excel based on column using power desktop automate?.. Wanna sort based on the data column in a descending order.
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.