web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering a nested gal...
Power Apps
Suggested Answer

Filtering a nested gallery based on child gallery content

(1) ShareShare
ReportReport
Posted on by elhughes19 57
Hi, I have a nested gallery with the parent gallery being projects and the child gallery being all the trials associated with that project. The projects data uses the sharepoint generated ID column and the trials data has a lookup column called 'Project ID' which links the two datasets together. I currently have some filters that can be used on the gallery however i'd like to add a year filter. Year is a Choice column in the trials dataset only (childgallery). How would I go about adding this filter into the gallery? I have tried to use copilot to help but i keep getting the same error of ID is not recognised. I have included my current gallery items code for the parent gallery, Any help on this is much appreciated.
If(
  IsBlank(Ownerfilter.Selected.Value) && IsBlank(projectnamefilter.Selected.Value) && IsBlank(BUfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  'MPT Tracker Projects',
  IsBlank(Ownerfilter.Selected.Value) && IsBlank(projectnamefilter.Selected.Value) && IsBlank(BUfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && !IsBlank(categoryfilter.Selected.Value) && categoryfilter.Selected.Value <> "All",
  Filter('MPT Tracker Projects', 'Category'.Value = categoryfilter.Selected.Value),
  IsBlank(Ownerfilter.Selected.Value) && IsBlank(projectnamefilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 'BU'.Value = BUfilter.Selected.Value),
  IsBlank(Ownerfilter.Selected.Value) && IsBlank(BUfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 'Project Name' = projectnamefilter.Selected.Value),
  IsBlank(projectnamefilter.Selected.Value) && IsBlank(BUfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 'Owner Email' = Ownerfilter.Selected.Value),
  IsBlank(Ownerfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value
  ),
  IsBlank(projectnamefilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value
  ),
  IsBlank(BUfilter.Selected.Value) && IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value
  ),
  IsBlank(Ownerfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value
  ),
  IsBlank(projectnamefilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value
  ),
  IsBlank(BUfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value
  ),
  IsBlank(brandfilter.Selected.Value) && (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All"),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value
  ),
  IsBlank(Ownerfilter.Selected.Value),
  Filter('MPT Tracker Projects', 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value && 
    (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All" || 'Category'.Value = categoryfilter.Selected.Value)
  ),
  IsBlank(projectnamefilter.Selected.Value),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value && 
    (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All" || 'Category'.Value = categoryfilter.Selected.Value)
  ),
  IsBlank(BUfilter.Selected.Value),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value && 
    (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All" || 'Category'.Value = categoryfilter.Selected.Value)
  ),
  IsBlank(brandfilter.Selected.Value),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All" || 'Category'.Value = categoryfilter.Selected.Value)
  ),
  Filter('MPT Tracker Projects', 
    'Owner Email' = Ownerfilter.Selected.Value && 
    'Project Name' = projectnamefilter.Selected.Value && 
    'BU'.Value = BUfilter.Selected.Value && 
    'Brand'.Value = brandfilter.Selected.Value && 
    (IsBlank(categoryfilter.Selected.Value) || categoryfilter.Selected.Value = "All" || 'Category'.Value = categoryfilter.Selected.Value)
  )
)
 
Categories:
Building Power Apps
I have the same question (0)
  • Petar Hr. Profile Picture
    Petar Hr. 18 on at
    Hi  elhughes19, 
     
    One this I can suggest from experience is that if you want to filter by a Choice column, you can treat the column as a "Data Source" via the Choices() function. 
     
    So, if I have a SharePoint list "My Projects", Choice column "Year" which have values "2024, 2025, 2026" and a Dropdown field that is used in the filter, I will try the below filter in my code: 
     
    Filter(
        Choices([@'My Projects'].'Year'),
        Value = 'Year Filter Field'.Selected.Value)
     
    I hope this helps! :)
     
  • Suggested answer
    Nandit Profile Picture
    Nandit 1,568 Moderator on at
     
    Is above the Items property of the Child Gallery?
    You can add a Combobox for Year on the screen and include the filter in the Child gallery. 
     
    Year Combobox Items:
    Choices([@DataSource].Year)
    Child Gallery Items:
    Filter(
    DataSource,
    true in ForAll(
        YearComboBox.SelectedItems,
        Value in Year.Value
    )
)
     
    Hope this helps. 
     
    Kind regards,
    Nandit
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
  • elhughes19 Profile Picture
    elhughes19 57 on at
    I have tried both the suggestions given but neither have worked. I can filter the child gallery by year no problem however when I do this all the projects remain visible in the parent gallery rather than filtering to only the corresponding projects and trials. Copilot gives this formula when asked however even though .Id and .Value seem to work in a label they are 'not recognised' when input into the parent gallery items property
     
    If(
    IsBlank(yearfilter.Selected.Value),
    'MPT Tracker Projects',
    Filter(
        'MPT Tracker Projects',
        ID in Filter('MPT Tracker Trials', Year.Value = yearfilter.Selected.Value).'Project ID'.Id
    )
)
     
     

     

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans