cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stevepttn
New Member

Cannot add row to excel table when its filtered.

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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:Annotation 2020-05-25 131311.jpg

 

Annotation 2020-05-25 131322.jpg

 

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.

View solution in original post

8 REPLIES 8
fchopo
Super User
Super User

Hello @Stevepttn 

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

Regards,

 

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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."
 

Flow.jpg

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

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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?

 

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:Annotation 2020-05-25 131311.jpg

 

Annotation 2020-05-25 131322.jpg

 

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.

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? 

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
Regular Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,953)