Answered

Filtering a Gallery based on matching key with another gallery

(0) Share

Report

Posted on by Power_Noob

I have an app with a Gallery that references a SP list (SP List 1), and forms that can be used to modify or add new items to that SP list. At the bottom of the "edit item" form that I created in the app, I have added another gallery that references related items from another SP list (SP List 2). I would like the filter the items in this gallery to show only SP List 2 items that are related to the SP List 1 item that the user is editing.

So, user selects item 1 of SP List 1. At the bottom of the form is a gallery of items from SP List 2 that pertain to the selected item in SP List 1 via a common key (i.e. Project ID =1, where there could be multiple items in SP List 2 that have been assigned Project ID = 1).

Getting the gallery to populate with items from SP List 2 is easy, but the filtering part is what I can't figure out. Does anyone know the code for such a gallery filter? Hopefully the ask makes sense and thank you for your time.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Power_Noob 17 on at

Like
a
(0)

Report
Copy link

Link copied!

This is what I currently have and does not work:
Filter('SP List 2,'Project ID' = 'SP List 1'.Selected.ID)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Power_Noob ,

You probably need

Filter( 'SP List 2,'Project ID' = FirstGalleryName.Selected.ID )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Power_Noob 17 on at

Like
a
(0)

Report
Copy link

Link copied!

That did the trick! Thank you!

Was this reply helpful? Yes No