cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
christianh2o
Frequent Visitor

auto sorting an excel table

All, 

 

I have a flow that adds rows into an excel table for onedrive. I'm looking for a way to autosort (custom) every time it runs based on column 1 then 2. Please advise. 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

Hi @christianh2o 

 

Just create an office script that runs on the excel file and sorts as you require.  You can record the script and call it from Power Automate.  https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

 

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

View solution in original post

1 REPLY 1
DamoBird365
Super User
Super User

Hi @christianh2o 

 

Just create an office script that runs on the excel file and sorts as you require.  You can record the script and call it from Power Automate.  https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

 

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,194)