Excel Scripts and Cloud Flows - Data Manipulation

[utterances-bot]

Excel Scripts and Cloud Flows - Data Manipulation

Have you discovered that the existing Power Automate actions for Excel are limited to Excel Tables?

https://pnp.github.io/blog/post/excel-scripts-and-cloud-flows-data-manipulation/

[akshanti]

Hi Damian!

Great stuff you have here, I have been watching some of your YT videos since I started my Power Automate adventure!

I have a question on the Select function titled 'Result from Excel Script Repurposed Using Select Array'. Could you show the expressions you used? I am not able to call any dynamic value from the previous step so I am guessing that there is a specific expression used for that.

P.S. I know this is an old post but I hope you could give me some pointers. Appreciate your help!

[LuiseFreese]

ping @DamoBird365/

[naherrera11]

Hi, DamoBird365, Why your second script includes letter F into F${lastrow}`; ?. It causes that Range selected is limited by this row A to F, how we can change it to be auto adjusted to the columns range? thanks