search

pnp / blog

holds all blogs published on the Microsoft 365 Platform Community blog
https://pnp.github.io/blog
MIT License
69 stars 101 forks source link

Excel Scripts and Cloud Flows - Data Manipulation #1504

Open utterances-bot opened 1 year ago

utterances-bot commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

ping @DamoBird365/

naherrera11 commented 1 month ago

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