Unanswered

filter gallery by gallery

(0) Share

Report

Posted on by Cosan

Hi
I have 2 galleries linked to 2 different SP Lists. In the app the user selects a provider from a dropdown. This then filters the 1^st gallery to show the clients that provider bid on. Data in List 1.
I want the 2^nd gallery to display the client data, which is in the 2^nd List. I want it to match up like below.

The 1^st gallery will always have multiple lines/results. The 2^nd gallery should show 1 line for each line in gallery 1.
I can only get the top line to work. This is the code I’m using

Filter(
    'Client input',
    Title = GalleryRFP.Selected.Title
)

Any advice would be helpful. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey ;)

can u try this code please:

ForAll( GalleryRFP.AllItems, Filter('Client input', Title = ThisRecord.Title) )

if it helped please mark as verifies answer,

cheers

Was this reply helpful? Yes No
Cosan 82 on at

Like (0)

Report

Hi mmbr1606

When I try that code the labels in gallery2 don't work because it doesn't recongise where its being directed.

Gallery 1 = GalleryRFP and List 1 = RFP

Gallery 2 = Gallery_client and List 2 = 'Client input'

With your code it seems to think the source data is RFP. It should be source 'Client input' sorted by GalleryRFP.

Thanks

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

thanks for trying and the reply,

can u try this modification:

Filter( 'Client input', Title in GalleryRFP.AllItems.Title )

cheers

Was this reply helpful? Yes No
Cosan 82 on at

Like (0)

Report

Hi mmbr1606

Same problem as 1st time. Its only working for the top line

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
what you can also try is to work with collections just like:

ClearCollect( colClientTitles, GalleryRFP.AllItems.Title )

and then filter that:

Filter( 'Client input', Title in colClientTitles )

you just would need to find the right place for the collection, maybe in the onselct of the dropdown,

if it helpled please mark as verified,

thanks

Was this reply helpful? Yes No