
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.
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