Announcements
Lookup formula in canvas app is taking only 1 value from entity.
How can I show multiple values in lookup ?
Lookup() by definition returns the first value it finds. If you want multiple values returned you need to use filter().
Can you provide me an example please ?
Here is the documentation:
Filter, Search, and LookUp functions in Power Apps (contains video) - Power Platform | Microsoft Learn
For Lookup it says:
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.
Not sure how to make that any clearer. Lookup always returns the first record and only the first record that it finds.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 239
