Canvas App Search and Filter , Delegation warning or Delegation Error

 

Search('PurchaseList',TextInput1.Text,"EID","PID","PList1")




or

If(IsBlank(TextInput3.Text),Policy,Search(Policy,TextInput3.Text,"Title"))

TextInput3 is the test search field name. 

Put the above formula for search functionality. 

If there are more records to search, make the delegation in setting from 500 to 2000 and use the below code. 

The Search() function is not Delegable, however with 100 rows, you can ignore the warning for now. If you are only looking for matching text (not text inside the field), you can use StartsWith(), with the added advantage of everything showing when the box is empty and filtering as you type. Make the Default of the box "" (empty string) and put this

 

Filter(
   'PurchaseList',
   StartsWith(EID,TextInput1.Text) &&
   StartsWith(PID,TextInput1.Text) &&
   StartsWith(PList1,TextInput1.Text)
)