web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Automate desktop excel...

Power Automate

Answered

Automate desktop excel using PA desktop

(0) Share

Report

Report

Posted on by sedaaver

3

Hello everyone,

I am new in using Power automate and I started my own project to practice what I've learned and I got stuck in the beginning. Can you help me to sort columns by the date?
What is my goal:
- read excel file
- sort the expenses by the month
- create new sheet with result columns sorted one next to each other by the month
(I attached sample of my excel data)

Problem is that I wanted to find a solution also when the excel do not have a headers.
I shouldn't be that difficult, right?

Thank you in advance!
Veroni

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sedaaver,

Do you want to sort Expense column based on month in your excel file?

@sedaaver wrote:

Problem is that I wanted to find a solution also when the excel do not have a headers.
I shouldn't be that difficult, right?

I am afraid that it is not possible in Power Automate, we must provide the column name when we sort columns.

The OData orderby expects the columns and their sorting order.

e.g. descending by month DateTime desc

As a workaound, you could write a script in your excel file and then use the Run Script action.

Here is a similar thread for your reference:

Sort excel table using power automate - Power Platform Community (microsoft.com)

To generate a new file with the sorted result, you just need to:
sedaaver 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much, I will give it a try 🙂
Best regards,
Veroni

Join the conversation