You’re offline. This is a read only version of the page.
Hi All,
We're getting an excel file report from the business that has more than 10K rows of data. Our requirement is to copy the entire data and overwrite it into another master excel file. I've already developed a flow but it takes hell out of time to complete this process.
Is there any other to achieve this faster?
Thanks.!
Hi, @Santhosh_V_26 ... There is an easier way to do this, which involves using the Office 365 Groups connector and the Send an HTTP request action there. You just have to get used to sending these commands.
When you have the value set from the get table (or get used range HTTP request - examples 1 & 2) just send it to the desired sheet using the add row function inside a Send an HTTP request.
This action can be used to add multiple rows at once, and so long as you are formatting it all correctly (the real hassle) then you should be able to do this in just a few actions. It will still take some time, but if you've not got any real formatting going on in either sheet, then you're on the money for a relatively easy time.
I would advise doing some testing, first, with small data sets, and this will enable you to better understand how to put together the request.
All of this said, the solutions provided by others might be a bit easier to understand, and implement (that's not an insult to anyone, that's what you want ... easy to understand), so if any of this is beyond where you are, then ... y'know ... ignoooooore! 😅
Full documentation is available on the docs site, here:
With Tables
https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http
Without Tables
https://docs.microsoft.com/en-us/graph/api/range-insert?view=graph-rest-1.0&tabs=http
You shouldn’t. I designed it so all you should have to do is edit things in the flow.
Did you find a bug/issue or something?
@Santhosh_V_26 @MarconettiMarco
If you go to the 3 ellipses (dots) on the Apply to each loop, then go to settings to change the concurrency settings & max it out.
But 10,000 updates will still take about 6 hours & may max out the daily calls your license can make.
The method mentioned above for batch processing may handle 10000 updates in less than 7 minutes and only use about 150 instead of 10000 calls.
It just requires that Office Scripts is available in your environment.
Thanks, @takolota & @MarconettiMarco for your response on this!
Below is my entire scenario,
We receive an excel file(.xlsx) with a table once a day that has approximately 10K rows with 6 columns. Once we received that we have to copy that data and then need to overwrite the data in our main excel file. I have developed a simple flow and it working fine but it takes around 5-6 hours to complete the process.
@MarconettiMarco, I haven't made any changes in the Concurrency control.
Kindly let me know if any details are required.
Thanks for your help!!!
@Santhosh_V_26 @MarconettiMarco
Need to update and/or create many rows in Excel?
Try Excel batch actions in Power Automate:
Demo Video:
Also about how many cells is your table?
And how many rows do you need to overwrite each time?
Hello @Santhosh_V_26 ,
have you already enabled the concurrency control into the Apply to each control?
BR,
Marco
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
4,156
