Unanswered

generete excel from canvas too slow in apply to each

(0) Share

Report

Posted on by vincenzos1984_1

117

Hi to all, i have a collection of 50-100 record and i need to generate an excel file, and i want insert in the row in the ordered manner, so i can't enable concurrent in apply to each...

is there another mode to optimize , or without apply to each, or with a script in excel ( i don't know scripting)...

thanks in advance..

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

EmadBeshai 806 Moderator on at

Like (0)

Report

Hi @vincenzos1984_1 ,

Please have a look to this article https://www.matthewdevaney.com/quickly-add-multiple-rows-to-excel-table-in-power-automate/

If this post helps you with your problem, please mark your as Accepted Solution.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
vincenzos1984_1 117 on at

Like (0)

Report

thanks a lot, work great

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

And if anyone needs to do this outside of OneDrive / in SharePoint, you can use office scripts like the batch create set-up here: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Was this reply helpful? Yes No