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?
Solved! Go to 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.
Hello @Stevepttn
Could you share a screenshot of your flow or share the error message?
Regards,
Ferran
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,
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?):
Hope it helps!
Ferran
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:
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
41 | |
36 | |
36 | |
22 |
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |