Wednesday, January 22, 2020

Filter, Search, and LookUp functions in Power Apps

Lookup
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.
If no record found, it will return Blank
LookUpTableFormula [, ReductionFormula ] )

ReductionFormula  = return value formula, it is optional parameter, if the value is not passed the entire record will be returned


Filter
The Filter function is used to find records in a table that meet formula criteria.
If no record found, it will return empty table
FilterTableFormula1 [, Formula2, ... ] )

Search
The Search function is different from Filter in that you are finding records that contain a string.
If no record found, it will return empty table.
SearchTableSearchStringColumn1 [, Column2, ... ] )

No comments:

Post a Comment