cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
solstice
Advocate I
Advocate I

Large Excel Tables write out

Hi, 

 

I have a problem that we hope there is an answer to or a development in progress.

We have a issue where we write out items to an excel table, using the "Add row to table" feature from the excel online connector, in a for each loop. 

The issue comes when items for this table start creeping up to 3000 - 4000 items and the API's just get exhausted and time is exponentially more insane with 2500 items almost taking 3 hours to write out.

 

Does anyone know of a quicker way to write out to excel file (table) such as a blob type style write-out vs having to go row by row?

We know from the read-in of the table is fast using the "list rows in table" action, where it grabs all at once, but looking for a way to write out all at once.

 

2 REPLIES 2
sumurthy
Microsoft
Microsoft

Have you tried using Office Scripts? 

https://docs.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration

 

The key would be to pass the data as a delimited string (not as an array) so that PA doesn't run the script one per row. 

On the script side, you can just parse it into array and use the table addRows API to insert rows. 

https://docs.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.table?view=of... 

The script should just take few seconds to complete. 

 

Anonymous
Not applicable

Solved.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (2,529)