Excel Online (Business) Create Table Error

[djmitz6]

Greetings,

I'm trying to create a flow that copies an excel file from one sharepoint site to another sharepoint site. Then the flow will need to convert the worksheet to a table. My flow is running correctly except for the Create Table function. I keep getting the error: "The operation failed because it conflicts with a filtered range." I'm assuming this means that, because my excel online file contains filters it cannot convert the range to a table. Is there anyway to remove filters from an excel online workbook?

[rohentz]

Hi @djmitz6 how are you?

Regarding your question and If I understood correctly your needs, to remove a filter in a table at Excel maybe you can create a script and then call it on Power Automate.

My sample below clear applied filter on my table "Tabela1"

And then I call it from Power Automate using this action. Just change the script name ok?

The run script action still on preview but you can check it at https://docs.microsoft.com/en-us/office/dev/scripts/tutorials/excel-power-automate-manual

Please let me know if this information helped on your question.

Regards.

Rodrigo Hentz

Microsoft Support Engineer

[djmitz6]

Rohentz,

Thank you for the response, but I'm trying to create a table. Currently the workbook is just a filtered range without a table. So running a script that calls a table that doesn't exist won't work.

[djmitz6]

@rohentz 

Here is an example of a filtered non-table: 

[rohentz · Accepted solution]

Hi @djmitz6  thanks for the reply and the sample. I recorded a new script and the code to clear the filter is:

Please let me know if this information helped on your question.

Regards.

Rodrigo Hentz

Microsoft Support Engineer