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)
Filter, Search, and LookUp functions - Power Platform - Microsoft Learn powerapps-data-table-filter
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.
: Add a "Data Table" control to your screen from the Insert tab. To filter a control in Power Apps, you
: Select your data source (e.g., SharePoint list, Excel table, or Dataverse).
: If the table appears blank, click Edit fields in the Properties pane to select which columns should be visible. Pro-Tip: Delegation If you see a blue underline or "delegation
The general formula for filtering a table is: Filter(DataSource, Condition1, Condition2, ...)