Power Fx function
Search — Power Fx function reference
Substring search across columns.
Syntax
powerfx
Search( Table, SearchString, Column1 [, Column2, ... ] )
Examples
powerfx
Search(Staff, txtFind.Text, "Name", "Email")
→ Matching rows
powerfx
Search(Products, txtSearch.Text, "Name", "SKU", "Description")
powerfx
Filter(Search(Staff, txtSearch.Text, "Name"), Department = drpDept.Selected.Value)
Common mistakes & gotchas
- Delegable on SharePoint and Dataverse for text columns.
- Search does a case-insensitive substring match; an empty SearchString ("") returns the whole table rather than zero rows, which is handy as a "no filter yet" default.
- Search is delegable on SharePoint/Dataverse text columns, but stacking additional non-delegable functions around it (as in the second example) can still hit the delegation limit on a large list.
Related Power Fx functions
From Filtering, search & sort