Clear filters in Excel worksheet Action(Power Automate Desktop)
This action clears the filter on the specified sheet or table.
This action was added in the March 2024 update.
How to use.
First, set up Launch Excel Action or Attach to running Excel and specify the target Excel file, and then.
Drag "Clear filters in Excel worksheet" from "Excel" under "Actions".
If you want to save your edits, you need to open the file in a non-read-only setting.
Set parameters.
The edited contents will not be reflected in the file as is.
If you wish to keep the edited content, you must save it using Save Excel Action or Close Excel Action at the end.
Parameters
Excel instance
Specify the Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel.
Clear filters in
Select how you want to specify the filters you want to remove.
- Active sheet
- Table
Active sheet
The entire active sheet.
There are no additional parameters to specify.
If you want to set the target sheet, set up the "Set active Excel worksheet" first.
Table
Specify the name of the target table.
Clear filters from specific column
If OFF, erases filters in all columns.
When ON, it erases the filter of only one column specified by an additional parameter.
If "Clear filters in" is "Active Sheet", specify by sequential number with column A as 1.
If "Clear filters in" is "Table", specify by column name.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.