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:

General Questions

All responses (5)

Answers (0)

mmbr1606 12,104 Super User 2025 Season 1 on at

Like (0)

Report
filter gallery by gallery

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
Cosan 73 on at

Like (0)

Report

filter gallery by gallery

Hi mmbr1606

Same problem as 1st time. Its only working for the top line
mmbr1606 12,104 Super User 2025 Season 1 on at

Like (0)

Report
filter gallery by gallery

hey

thanks for trying and the reply,

can u try this modification:

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

cheers
Cosan 73 on at

Like (0)

Report

filter gallery by gallery

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
Suggested answer

mmbr1606 12,104 Super User 2025 Season 1 on at

Like (0)

Report
filter gallery by gallery

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