: Select the Data Table, go to the Items property in the property dropdown, and enter your Filter formula.
The general formula for filtering a table is: Filter(DataSource, Condition1, Condition2, ...)
To filter a control in Power Apps, you must modify its Items property using the Filter function. This allows you to display only the records that meet specific criteria, such as a value selected from a dropdown or text entered into a search box. Basic Filter Syntax powerapps-data-table-filter
: Select your data source (e.g., SharePoint list, Excel table, or Dataverse).
Filter, Search, and LookUp functions - Power Platform - Microsoft Learn : Select the Data Table, go to the
If you want to filter a table based on a choice made in a dropdown (e.g., filtering a "Projects" list by "Status"): Items = Filter(Projects, Status.Value = Dropdown1.Selected.Value)
: If the table appears blank, click Edit fields in the Properties pane to select which columns should be visible. Pro-Tip: Delegation Basic Filter Syntax : Select your data source (e
You can combine multiple conditions using the && (AND) or || (OR) operators: Items = Filter(DataSource, Status.Value = Dropdown1.Selected.Value && Amount > 1000) Step-by-Step Setup