Filter, Search, and Lookup functions in PowerApps compared. – Nishant Rana’s Weblog

Nishant RanaDyn365CE7 years ago160 Views

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

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
January 2026
MTWTFSS
    1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  
« Dec   Feb »
Follow
Search
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...

Discover more from 365 Community Online

Subscribe now to keep reading and get access to the full archive.

Continue reading