Power Platform Community Forum Thread Details

"This won't work because it would move cells in a table on your worksheet."

Hello All,

So this is a ongoing battle for me and I hope this community can help with with a resolution.

I'm the owner of multiple Power Automate Flows that uses Excel to store data collected from forms.

if someone filters these excel file and a flow is triggered in the mean time, it wont impact the flow and the row will be updated on a excel file when filter is removed.

This is true for all BUT one power automate flow.

All my excel files (including one erroring) are in xlsx format.

does anyone know how to fix this?

Thank you in advance!!

Categories:

Error handling

I don't even know whats wrong, you sort of explained but not really.

I don't see the flow

I dont' see any error messages

But that type of error is usually because you are trying to insert data into a Column that isn't there based on your range and having the flow try to update it WOULD in fact shove the table to the right, which it will not do.

Please verify that your Range covers exactly and only whats in the file you are trying to update.

It thinks you are providing the wrong range.

Although, if we can see the flows and the messages there, it would help. All the stuff that works is irrelevant and can be left out in future questions, just tell us whats broken, errors and what you expect or want :-) otherwise its just confusing to figure out what is what.