web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery Lookup Conditi...

Power Apps

Answered

Gallery Lookup Condition only shows the first matched record from the table

(0) Share

Report

Report

Posted on by WillieEra

45

Hi,

I created a gallery based on a lookup on the selection of another gallery, however once selected the gallery only shows the first matched record as per the condition.

Items = LookUp('[dbo].[ew_arm_insurar_dim]',Insurance_Client_Key = Gallery_Clients_1.Selected.Client_ID)

Is there something I am missing?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@WillieEra

To return a table of results you'll want to use FILTER instead. The LOOKUP function will only retrieve the first matching result.

Filter('[dbo].[ew_arm_insurar_dim]',Insurance_Client_Key = Gallery_Clients_1.Selected.Client_ID)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
WillieEra 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Solved my problem, thank you!

Join the conversation