Filter, Search, and Lookup functions in PowerApps compared.


Very informative !

Something Awesome About ... dynamics, crm, ce, powerapps, business apps...

These are functions to find one or more records in a table.

 Matches by a formula or a single string *Multiple formulas acceptedReturns multiple

records or a single record

Returns the subset of the original dataset or one valueNo record foundFunction to check if no record found
FilterFormulaYesMultipleSubsetEmpty tableIsEmpty
SearchStringNoMultipleSubsetEmpty tableIsEmpty
LookupFormulaNoFirst SingleOne valueBlankIsBlank

*The formula is evaluated for each record of the table. Records that result in true are included in the result. Besides the normal formula operators, you can use the in and exactinoperators for substring matches.

Fields of the record currently being processed are available within the formula. You simply reference them by name as you would any other value. You can also reference control properties and other values from throughout your…

View original post 287 more words

Advertisements

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.