How to remove filter in excel online sheet?

(0) Share

Report

Posted on by frixel2

Hi All,

Is it possible for delete an filter in online Excel sheet.

My files have that filter and now i cant create a table with power automate.

How can i resolve that?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @frixel2,

It would be possible by using Office Scripts and the Run scripts action:

https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

Below is an example.

1. Create an Office Script in the Excel Online File. This should be possible via the Automate tab.

In this example I am clearing the filter from Column B in my Table1

function main(workbook: ExcelScript.Workbook) { let table1 = workbook.getTable("Table1"); // Clear filter on table table1 column B table1.getColumnByName("B") .getFilter() .clear(); }

2. Add Run script action to your flow and run this script for your Excel file

Was this reply helpful? Yes No
frixel2 54 on at

Like (0)

Report

@Expiscornovus
Thanks for your answer, that keeps me opportunnities.

I have try it with the script so you tells above.
But this script is not remove the filter option from al fiels, This is a script for clear filter(s).
is it also possible for deleting the filter?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @frixel2,

My script was just an example. You should be able to record your specific office script with the action recorder. So, I believe that would be possible.

Have a look at this:

https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel#action-recorder

Was this reply helpful? Yes No
GU22 3 on at

Like (0)

Report

Thank you!! This solves a really annoying problem!

Was this reply helpful? Yes No