Unanswered

Sort an excel table

(0) Share

Report

Posted on by Kevor

I have a simple flow that takes information from a form and adds it to an excel table, I would like the flow to proceed and sort the excel table by the date column, newest to oldest, before saving it.

I thought this would be quite straightforward but having spent the afternoon trying apparently it is not?

I have used:

When a new response is submitted

Get response details

Add a row into a table

Can anyone enlighten me what next and how please?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @Kevor

Office Scripts would be the best bet. Use the office script recording tool in Excel Online, record the actions you describe, give the script a name and call the office script action on the file you mention after you have inserted the row, if you really wanted to be efficient, insert the row and order the rows with an office script. I have a few demos on my YT but the Microsoft docs are very good for this too with some good examples. Introduction to Office Scripts in Excel (microsoft.com)

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

Was this reply helpful? Yes No
Kevor 13 on at

Like (0)

Report

Thanks for your reply, however whenever I try to record a script in Excel online I get the error "We're unable to save your script. An unexpected error occurred while generating and saving your script....."

I was able to record a macro in the desktop app of Excel but I can't seem to reference it within power automate.

Was this reply helpful? Yes No