cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stewie2
New Member

Slow creation of rows in excel table.

Hi, I have a flow that will create an excel table in a sharepoint site. I am creating more than 400 rows in a table. does it really take more than an hour to finish? 

please help.

Thank you.

stewie2_0-1668075480215.png

stewie2_2-1668075584221.png

 

 

1 REPLY 1
Sundeep_Malik
Community Champion
Community Champion

Hey @stewie2 

 

Sometimes these things happen with excel. I would suggest you two things:

 

  • Go to settings of apply to each and open the option of concurrency.
  • 2nd method is the better part. You can create scripts of excel part. Providing link for the same below:

 

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-...

 

The second method is the best, and will help you to a great extent. If you get any questions in that you can reply in that post or directly ask @takolota here only. He is the creator of that post.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,122)