In today’s post we’ll talk about an error I faced while working with complex Excel files. So if you are working with the Excel (for business) connectors and Excel templates, read on!
Scenario
The full scenario was getting some outputs from an AI Prompt in Power Automate, and sending this data into a complex Excel template. When you work with the Excel connectors, the “nicely” formatted layouts need to be converted into tables.
If your Excel template has multiple tables in a stacked layout, you would think that whatever we can do manually will work. However, this is not necessarily the case with this connector.
Add a row action
If you’ve worked with Excel (for business) in Power Automate before, this action will be familiar. We use it to insert values dynamically, and that offers flexibility in our automation processes. Let’s say we have 2 tables and we use Power Automate to fill data into them.


When the flow runs successfully, we’ve got our data into the correct table, and it pushed the table underneath further. The same results as if we were doing it manually 🙂

However, by complex Excel template I meant “not everything is the same”.
Power Automate error
Amongst other possibilities as to why your flow fails on the Add a row, you might not be realising that this time, the manual actions are not working with the connector. Let’s imagine my template layout looks like below:

Running the flow, and we get that! 😟
Flow run failed. Action ‘Add_a_row_into_a_table’ failed: Graph API conflict response. Error code is ‘InsertDeleteConflict’. Error message is ‘This won’t work because it would move cells in a table on your worksheet.’
The error message gives you a little hint, and this due to the fact that the table underneath the first one is not the same. It has one more column, and that makes the flow fail unfortunately.
Conclusion
This is one of the Excel connector limitations, but an important one to avoid scratching your head for hours. If you need to keep the stacked layout with different tables across columns, your best bet is to use Office Scripts. Or if you can get the tables into separate worksheets, then you won’t face the issue.
Thanks for reading! 🙂