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

  1. Sign in to Power Apps.

  2. Expand Data, select Tables, select the table that you want, and then select the Views area.

    You may want to navigate to the table via the solution. If so, go to Solutions, select your solution, select the table, and then select the Views area.

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

    View panel filters.

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

    Edit filters.

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

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

  7. Select Apply.

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

Open the expression builder

  • On the view properties panel, select Edit filters.

    Expression builder.

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.

    Filter condition.

  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.

    Group condition filter.

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

  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.

    Related table filter.

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

    Grouped condition filter.

Next steps

Configure sorting in views
Converting views into editable grids