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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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 (2,580)