Power Platform Community Forum Thread Details

I was wondering if theres a way to sort an excel spreadsheet using Power Automate. The flow I have set up would be triggered on a file creation in One Drive (excel sheet added to Drive), and Ideally sort the Data by the "Name" column.

I know you can simply just sort manually via "sort" in the Excel sheet, but I was wondering if theres a way to automate this or even set a rule up in Excel that will automatically sort alphabetically.

Categories:

General topics

Hi @jokanol1

Office scripts can do this for you. There is a recording tool in Excel Online that would let you record a script based on your real time actions. This builds a typescript office script that you can then call from the Run Script Action in Power Automate and repeat the actions in excel that you have just recorded. It's relatively easy to use and I have a few demo's on my YT if that is of interest. Otherwise the MS Docs for Office Scripts are really quite good.

Office Scripts in Excel on the web - Office Scripts | Microsoft Docs

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