Filter cells in Excel worksheet Action(Power Automate Desktop)
This action applies a filter to a specified range or table.
If it is already filtered, the behavior is as follows:
- If the targeted range is the same as the one the previous filters were applied on, all filters are applied.
- If the targeted range isn't the same as the range previous filters were applied on, previous filters are cleared, and only the latest one is applied.
- If the targeted range is a table, all filters are applied.
How to use.
First, set up Launch Excel Action or Attach to running Excel and specify the target Excel file, and then.
Drag "Filter cells 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.
Filter column in
Select how to specify the range to be filtered.
- Active sheet
- Range
- 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.
Range
Select "Named cells" or "Specific range" as the range designation method.
Named cells
Specify the "Cells name".
Specific range
Specify the sorting target by Start column/Start row/End column/End row.
The first row and column are sequential numbers of 1.
Column to filter
Specify the target column.
If "Filter column in" is "Active Sheet" or "Range", specify sequential numbers with the first column as 1.
If "Filter column in" is "Table", specify by column name.
Filters to apply
Click the "Edit" button to open the "Filters to apply" window.
Click "+" to add a rule. At least one rule is required.
Turns " Advanced" on or off. There are the following differences.
| - | ON | OFF |
|---|---|---|
| Number of rules. | Up to 2 pieces. | Multiple. |
| Rule Type. | AND OR | OR |
| Conditional type. | Various conditions are possible(see below). | Only "Equal to(=)" |
Rule
OFF is useful for multiple fixed values.
In the example below, "A", "C" and "E" are hidden.
ON is useful when you want to specify a range of values.
In the example below, " greater than or equal to 1 and less than or equal to 100" will be hidden.
Conditional
Select from the following:
- Equal to (=)
- Not equal to (<>)
- Greater than (>)
- Greater than or equal to (>=)
- Less than (<)
- Less than or equal to (<=)
- Contains
- Does not contain
- Is empty
- Not empty
- Starts with
- Does not start with
- Ends with
- Does not end with
If " Advanced" is OFF, only "equal to (=)" is available.
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.