Cannot add row to excel table when its filtered.

[Stevepttn]

I am unable to add a new row into a table when the table has been filtered with a slicer. 

Is there any way around this?

[fchopo]

Hello @Stevepttn 

Could you share a screenshot of your flow or share the error message?

Regards,

Ferran

[Stevepttn]

This is the error message I am getting when my table is filtered.  But the flow works when the table is not filtered. 

  "status": 409,

  "message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: b51a3a6f-f3bf-4039-8f30-f79eb2e20bed\r\nserviceRequestId: 8450aae2-1b30-433e-bc72-98af9b0555de;4a1a4fb5-9abc-48d9-a827-b1054c5853bb",

  "error": {

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

[fchopo]

Hello @Stevepttn 

Have a look at this thread with the same problem as yours: https://powerusers.microsoft.com/t5/Building-Flows/Error-409-This-won-t-work-because-it-would-move-c...

It is because of the table arrangement (do you have any other tables in the same sheet?):

https://techcommunity.microsoft.com/t5/excel/getting-this-message-quot-this-won-t-work-because-it-wo...

Hope it helps!

Ferran

[Stevepttn]

Hello,

There is only one table on the sheet. I have slicers above the table and the flow will work if the table is not filtered with the slicers. But as soon as I add a filter with the slicer the flow fails and gives me this error.

Is there any way to un-filter my table during the flow?

[v-litu-msft · Accepted solution]

Hi @Stevepttn,

I have tested that add a row into a table and the Excel table has filtered slicers, but not found the same issue:

Whare is the Excel file store in? Maybe you could store it in a SharePoint library and try it again.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Stevepttn]

Hello,

The excel file is stored in a SharePoint library. The flow works when the table is not filtered and doesn't when it is filtered. I have not yet found a solution. Could it be the flow? 

[v-litu-msft]

Hi @Stevepttn,

I don't think it is caused by Flow, cause on my side it not happened the same issue, maybe you could create a simple example to test it again.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mensahupmc]

You could add an Excel Script step to first un-filter your table