cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
solstice
Frequent Visitor

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. 

 

Solved.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (54,099)