Announcements
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!
@Anonymous
Try this
Filter( YourDataSourceName, Companyxxx = Text(PropertyGallery.Selected.Companyxxx) )
@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.
What's main Gallery which your trying to filter from, is it GroupBy or in the gallery items
@Ramole, it is the gallery items. I am not using a GroupBy.
Yes, can you post some screenshot, so I can see why is blank and also what's the field type backend SharePoint etc.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305