Exporting over 700k rows into excel file in network drive by using power automate

Power Automate
1

How to export over 700k rows into excel file in network drive by using power automate?

2

Here are some logical generic steps to export over 700k rows into an excel file stored on a network drive by using power automate:

  1. Create a new flow in power automate and select the trigger that suits your scenario. For example, you can use a button, a schedule, or an event.
  2. Add an action to get the data from your source. For example, you can use SQL Server, SharePoint, or Excel Online.
  3. Add a loop control to iterate over the data and split it into batches of 100k rows each. You can use an array variable to store the batches.
  4. Add another loop control inside the first one to iterate over each batch and create a CSV file with the data. You can use the create file action and specify the network drive path and file name.
  5. Add an action to convert the CSV file to an excel file. You can use the convert file action and specify the input and output formats.
  6. Add an action to delete the CSV file after converting it. You can use the delete file action and specify the network drive path and file name.

  • Repeat steps 4 to 6 for each batch until all the data is exported.

  • Add any other actions you need to complete your flow, such as sending an email notification or logging the results.

It is very important to throttle the batch size.

In this example, the batch size is 100k rows though you may find due to your specific network conditions that this should be a lower number.

3

Hello @hansen.dina

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

Hi @hansen.dina

Due to inactivity, we’d like to conclude that you no longer require assistance to solve your inquiry.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.