How to remove filter in excel online sheet?

Like (0) Share

Report

Posted on 11 Mar 2021 15:01:26 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?

All responses (4)

Answers (1)

GU22 3 on 11 May 2023 at 00:43:06

Like (0)

Report

Re: How to remove filter in excel online sheet?

Thank you!! This solves a really annoying problem!
Expiscornovus 31,728 Most Valuable Professional on 12 Mar 2021 at 09:31:37

Like (0)

Report

Re: How to remove filter in excel online sheet?

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
frixel2 54 on 12 Mar 2021 at 08:57:27

Like (0)

Report

Re: How to remove filter in excel online sheet?

@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?
Verified answer

Expiscornovus 31,728 Most Valuable Professional on 11 Mar 2021 at 16:07:21

Like (2)

Report
Re: How to remove filter in excel online sheet?

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