Powerapps-data-table-filter
To show records where a specific column contains the text typed into a Text Input control: Items = Filter(DataSource, TextInput1.Text in ColumnName)
: If the table appears blank, click Edit fields in the Properties pane to select which columns should be visible. Pro-Tip: Delegation
Filter, Search, and LookUp functions - Power Platform - Microsoft Learn
: Select your data source (e.g., SharePoint list, Excel table, or Dataverse).
: Add a "Data Table" control to your screen from the Insert tab.
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
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.
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