Unanswered

Filter a lookup in a gallery

(2) Share

Report

Posted on by Anonimous

I have a gallery linked to a data source "Stocks" which has an 'Item ID' attribute which is a Lookup to our "Items" entity, which has a 'Lab Team' attribute which is a Lookup to our "LabTeams" entity

I have a dropdown above my gallery populated with the distinct LabTeam values in my Dataverse table, which when selected I want to filter the rows in the gallery on

My issue is that my gallery data source "Stocks" has no 'Lab Team' field - how would I access this from the gallery to filter its records to include the selected dropdown value?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ram Prakash Duraisamy 5,885 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Anonimous

You can try below

Filter(Stocks,'FILED NAME' = Dropdown1.Selected.Result)

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Anonimous 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rampprakash,

Thank you for your reply

Unfortunately this solution can't work as our field name ('Lab Team') isn't in our data source

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,885 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Anonimous

If that is the case we need to create a lookup field, we need to have a relationship to filter the Gallery.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Anonimous 8 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Rampprakash,

I currently have the following expression to get the column into the gallery

LookUp(LabTeams,LabTeam=LookUp(Items_1,Item=ThisItem.'Item ID'.Item).'Lab Team'.LabTeam).Name

So i do have a relationship established, it's just via the Items table.

Was this reply helpful? Yes No