Unanswered

Power Automate Flows fails when adding rows in a table

(0) Share

Report

Posted on by GM-27081910-0

I´ve designed a flow to get some info from the body of an e-mail and then save it in an excel file table but I´m getting the error message "This won't work because it would move cells in a table on your worksheet". Any help would be deeply appreciated.

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 50,275 Super User 2025 Season 2 on at

Like (1)

Report

Power Automate Flows fails when adding rows in a table

Hi @GM-27081910-0

I would need to see the values you have, because the error itself is because the values you are supplying would force the table to move data and essentially break the table.

Make sure you are targeting the correct area in your Table, as I cannot see the Table etc I can tell you, that you need to verify the Table range and then verify that in your calls to add data.

Be super careful you are not pasting outside the boundary of the table, or accidentally over a table (partially). That is what this means.

So if the Table is Range A1-A2:B1:B2 you are essentially going from inside there to C1 for instance which is not allowed as it would break the table.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
GM-27081910-0 7 on at

Like (0)

Report

Power Automate Flows fails when adding rows in a table

The data to be inserted into the table are as follows:

And right now the excel table is still empty:

Was this reply helpful? Yes No
Michael E. Gernaey 50,275 Super User 2025 Season 2 on at

Like (0)

Report

Power Automate Flows fails when adding rows in a table

Hi @GM-27081910-0

Can you please share, in Excel the Table as I do not see a table around that data.

Was this reply helpful? Yes No