These are functions to find one or more records in a table.
Matches by a formula or a single string * | Multiple formulas accepted |
Returns multiple
records or a single record |
Returns the subset of the original dataset or one value | No record found | Function to check if no record found | |
Filter | Formula | Yes | Multiple | Subset | Empty table | IsEmpty |
Search | String | No | Multiple | Subset | Empty table | IsEmpty |
Lookup | Formula | No | First Single | One value | Blank | IsBlank |
*The formula is evaluated for each record of…
Continue Reading Nishant Rana’s Article on their blog
Filter, Search, and Lookup functions in PowerApps compared. – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission