Step-by-Step Guide to Fix Power Automate Excel “Add Row into Table” Overwriting Issue
---
Background:
When using Power Automate to add multiple rows into an Excel table — especially with columns containing formulas like hyperlinks — sometimes the first column (e.g., Link) gets overwritten in all rows by the value from the last row. This usually happens because of concurrency and API timing issues.
---
Objective:
Ensure each row inserts correctly with unique data without overwriting columns.
---
Steps:
1. Open your Power Automate flow
Go to Power Automate and open your flow.
2. Find the “Apply to each” loop
Locate the loop where you add rows to Excel.
3. Disable concurrency control on the loop
Click the three dots (•••) on the top right of the “Apply to each” action.
Choose Settings.
Toggle Concurrency Control to Off (set Degree of Parallelism = 1).
Save changes.
This ensures rows are processed one after another, preventing overwrites.
4. Add a delay inside the loop
Inside the loop, after the Add a row into a table action, add a Delay action.
Set the delay for 2 seconds (00:00:02).
This pause allows Excel API to process each row fully.
5. Verify input data before the loop
Add a Compose or Create HTML Table action before the loop, referencing your array.
Run the flow and inspect output to confirm each row’s data is correct.
6. Optionally simplify row creation
Build each row dynamically inside the loop rather than using a separate Select action.
7. Save and test your flow
Run with test data and confirm all rows appear correctly in Excel, with unique links and data.
8. Adjust delay if needed
If issue persists, increase delay time incrementally (3–4 seconds).
---
Notes:
This behavior is common due to Excel Online API limitations.
Disabling concurrency and adding delay are the most effective workarounds.
Always verify the data being sent to Excel is correct and complete.
