How to rearrange Excel column via Power Automate

(0) Share

Report

Posted on by Community Power Pla...

Hello,

Each month i have a report with many columns, to be able to use the data in it, i need to rearrange the columns.

The issue is that each time i download the report the columns there are with different arrangement of the columns.

In example: if i have columns A - user, B - data, C - value -

to use them i need to rearrange to - A - value, B - user, C - data

but as i mentioned i need to use the column name for rearrange, as next time the columns can be in different sort.

Can somehow add them all in a list via power automate and take the column in predefined structure?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Mitanshu 1,650 Moderator on at

Like (0)

Report

Re: How to rearrange Excel column via Power Automate

Assuming:
1 - "name" of your column will always remain same, so user will always be user even if it is in column A or B,...
2 - your data is formatted in a Table, and stored on cloud
3 - File name and storage locations remains the same

Solution:
1 - List rows present in a table, provide location of your file (OneDrive, SharePoint Document Library,...)
2 - Add Select action and create the mapping in your desired column order
3 - Apply to Each on the output for Select
4 - Add Rows to a different Excel file (your desired column order from Select will be retained).

Edit:
If you want to add items to a SharePoint List from Excel, then you don't need Select step. Simply List rows present in a table -> Apply to Each -> Create Item in SharePoint. Under the SharePoint List interface, reorder the column once as per your desired use-case

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to rearrange Excel column via Power Automate

Hello, thanks a lot for above instructions, but could you be please more specific with the Select function, what should i put on Key and Value?

Was this reply helpful? Yes No