Power Platform Community Forum Thread Details

I am facing an issue while copying and merging Excel data using Power Automate Cloud.

I am expecting 341 records to be copied into my destination Excel file, but after the flow runs, only 257 rows are inserted. There is no error thrown by the flow, and the execution shows that all rows were processed successfully; however, the Excel table ends up with fewer rows than expected.

My Setup:

Source and destination Excel files are stored in OneDrive for Business
Using Excel Online (Business) – Add a row into a table / Office Script method
Destination table has 5 columns:
Date, ReferenceNum, EmailID, BotID, Status
The file is closed during the run
No filters applied manually
But when data is inserted, some rows appear to be skipped or overwritten, causing missing data

Issue Details:

Total expected rows: 341
Rows inserted into Excel: 257
Approximately 84 rows are missing
This seems related to Excel Online limitations or table corruption, but I’m not fully sure

What I Tried:

Rebuilt the table
Ensured the file is closed
Used bulk insert via Office Script (table.addRows)
Enabled pagination
Checked for hidden/filtered rows
Split data into chunks
Verified the source actually contains 341 items
Despite the above, the issue still persists.

Request for Help:

Why is Excel Online dropping/skipping rows during table insert?
Is this a known limitation of Excel Online connectors?
What is the recommended method to reliably insert 300–500 rows into an Excel table without losing data?
Should I clear the table first before bulk inserting?
Is there a workaround such as using ranges instead of table rows?

Any guidance, recommended patterns, or fixes would be greatly appreciated.

Thank you in advance!
Sayed Tabrez

Categories:

Connector development

Building flows

Using flows

Hi @ST-04061713-0,

Based on your description, the problem seems to be on the origin file. By default, the List rows present in a table action from Excel retrieves only up 256 records (I don't know from where are you getting the record 257).

To solve it, there are a few options. The easiest one is just to configure the pagination. Go to settings (in yellow) and set it to a number that works for you - it will limit the results to this quantity of records:

Unless you have more than a few thousands of records, this approach may be enough.

If you want a scalable solution, you must work with the Graph API or Office Scripts to retrieve the records. If you want to learn more about these alternatives, check the following blogs that I wrote about it:

- Get started with Office Scripts: https://digitalmill.net/2023/06/19/get-started-with-office-scripts/

- Reading data from Excel tables with Office Scripts: https://digitalmill.net/2024/10/28/reading-data-from-excel-tables-with-office-scripts/

- What is Microsoft Graph API and how to use it?: https://digitalmill.net/2026/02/09/what-is-microsoft-graph-api-and-how-to-use-it/

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn