Create or edit filters in model-driven app views

The filters in a Power Apps view define the records that a user will be able to see when selecting the view for the current table. You can add or edit a filter for the columns that you include in a view by selecting the column and selecting Filter by. You can also use the expression builder in the view designer. Use the expression builder to add or edit filters for any columns of the table in the current view or any columns in a related table.

In this article, you create or edit filters by performing the following tasks:

• Edit or remove a filter condition

• Open the expression builder

• Add conditions to a filter

• Add a group condition to a filter

• Add a related table to a condition

• Group conditions of a filter

Edit or remove a filter condition

1. Sign in to Power Apps.

2. Select Tables, open the table that you want. If the item isn’t in the side panel pane, select …More and then select the item you want.

3. Select the Views area.

   To open the table from a solution, go to Solutions, select your solution, select the table, and then select the Views area.

4. Select a view to open it. The view properties panel lists existing filters.

   

5. On the view properties panel, select a filter condition.

   

6. Select the conditional operator that you want to use.

7. Type or select the comparison value for the condition.

8. Select Apply.

9. To remove a condition, select Close. The condition is removed without confirmation.

Open the expression builder

• On the view properties panel, select Edit filters.

  

Add conditions to a filter

1. In the expression builder, select Add > Add row.

2. Select a column for the condition.

3. Select a conditional operator.

4. Select a comparison value.

   Some filter conditions don't require a comparison value for the condition. For example, the operator Contains data doesn't require a comparison value. With other filter conditions, you choose the comparison value from an option set. For example, the Status column has an option set that contains the values Active and Inactive.

   

5. Select OK.

Add a group condition to a filter

1. In the expression builder, select Add > Add group.

2. Select the relational operator Or for the group. And is the default relational operator.

3. Specify the first clause of the grouped condition. Select the column, conditional operator, and comparison value.

4. Select Add > Add group

5. Specify the second clause of the grouped condition.

   

   You can select Collapse to display the group as a conditional expression.

Add a related table to a condition

1. In the expression builder, select Add > Add related table.

2. Select a column from the current table that is related to another table. The table related to the column is shown in parenthesis. You can select columns that have a many-to-one, one-to-many, or many-to-many relationship with the related table.

3. Select a column of the related table for the condition.

4. Select a conditional operator.

   Note

   Contains data is the only conditional operator that can be used with a related table in a view filter.

5. Select or enter a comparison value.

   

Group conditions of a filter

1. In the expression builder, select the check box for the conditions that you want to group.

2. Select More commands (...) for one of the conditions, and then select Make group.

3. To ungroup a group, select More commands (...) for the group, and then select Ungroup

   

Next steps

Configure sorting in views
Converting views into editable grids