Powerapps-data-table-filter -
: If the table appears blank, click Edit fields in the Properties pane to select which columns should be visible. Pro-Tip: Delegation
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
To show records where a specific column contains the text typed into a Text Input control: Items = Filter(DataSource, TextInput1.Text in ColumnName) powerapps-data-table-filter
The general formula for filtering a table is: Filter(DataSource, Condition1, Condition2, ...)
: Add a "Data Table" control to your screen from the Insert tab. : If the table appears blank, click Edit
: Select the Data Table, go to the Items property in the property dropdown, and enter your Filter formula.
When filtering large data sources (like SharePoint or SQL), ensure your filter query is . If you see a blue underline or "delegation warning," Power Apps may only process the first 500–2,000 records of your data source rather than the entire set. Basic Filter Syntax To show records where a
: Select your data source (e.g., SharePoint list, Excel table, or Dataverse).