Filtering Gallery with Another Gallery

Like (0) Share

Report

Posted on 6 Aug 2021 00:58:16 by Community Power Pla...

I have a gallery (Gallery1). I want to filter Gallery2 based on Gallery1. I am using a filter function in Gallery 2 that looks like this: Filter(Tablename,UNIQUE_ID = Gallery3.Selected.PART_SUB). UNIQUE_ID in the datasource table for Gallery2 and PART_SUB in Gallery1 is the linkage between the two tables. The formula doesn't throw any errors but the item fields in Gallery2 are blank. No matter what I try to do they will not show any data. I am perplexed and and guidance is appreciated!

All responses (6)

Answers (0)

Community Power Pla... on 06 Aug 2021 at 15:42:19

Like (0)

Report

Re: Filtering Gallery with Another Gallery
Ramole Super User 2024 Season 1 on 06 Aug 2021 at 02:40:53

Like (0)

Report

Re: Filtering Gallery with Another Gallery

@Anonymous

Yes, can you post some screenshot, so I can see why is blank and also what's the field type backend SharePoint etc.
Community Power Pla... on 06 Aug 2021 at 02:29:33

Like (0)

Report

Re: Filtering Gallery with Another Gallery

@Ramole, it is the gallery items. I am not using a GroupBy.
Ramole Super User 2024 Season 1 on 06 Aug 2021 at 02:07:13

Like (0)

Report

Re: Filtering Gallery with Another Gallery

@Anonymous
What's main Gallery which your trying to filter from, is it GroupBy or in the gallery items
Community Power Pla... on 06 Aug 2021 at 01:31:50

Like (0)

Report

Re: Filtering Gallery with Another Gallery

@Ramole, Thank you for your reply. I just tried this: Filter(Z05_Put_Away_Locationss,UNIQUE_ID = Text(BrowseGallery3.Selected.PART_SUB)) and it still did the same thing.
Ramole Super User 2024 Season 1 on 06 Aug 2021 at 01:27:21

Like (0)

Report
Re: Filtering Gallery with Another Gallery

@Anonymous

Try this

Filter( YourDataSourceName, Companyxxx = Text(PropertyGallery.Selected.Companyxxx) )