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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Nested Gallery Filtering
Power Apps
Answered

Nested Gallery Filtering

(0) ShareShare
ReportReport
Posted on by aayaanmayank 248

Hi Everyone - Can someone please help me i have 3 galleries Gallery 2 is under Gallery 1. based on the gallery 2 selection i need the out on Gallery 3, as of it is Filtering data based on gallery 1.

Items Property in Gallery3 - GroupBy(Filter('ABC','Root Causes' in Root_Map && ' Solution Impact Lever' in Lever),"Solution","Data")

Attached is the screenshotScreenshot.PNG 

Categories:
Building Power Apps
  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    Can anyone please help? @WarrenBelz @Drrickryp @BCBuizer 

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @aayaanmayank ,

     

    To be honest your description doesn't really give the level of detail required to give a focused response.

     

    What data source are you using? What column are do you want to filter? What is the data type of the column your want to filter? When you say Selection in Gallery2, do you mean checked items? What is the data source of Gallery2? 

     

    Please elaborate.

  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    I am using Share point as Data Source for all the galleries. 

    Gallery 1 checkbox Oncheck property is Collection (Root_Map) 

    Gallery 2 Items Property is GroupBy(Filter('ABC','Root Causes' in Root_Map),"SolutionImpactLever","Data")

    Based on Gallery1 i am getting (Technology, Process, People) in gallery2

    Gallery 2 Checkbox Oncheck property is Collect(Lever,LookUp(Lever,Gallery2.Selected.Checkbox2.Value))

    when i select checkbox e.g. Technology it should only show data on gallery 3 basis the check box selection

    Gallery 3 Items Property is GroupBy(Filter('ABC','Root Causes' in Root_Map , ' Solution Impact Lever' in Lever),"Solution","Data")

    gallery3 is getting data from column named "Solution"

     

    Hope i am making sense now

  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    We can connect on zoom if it is still not clear to you

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    HI @aayaanmayank ,

     

    Thanks for this additional information. And where during the process are you getting stuck?

  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    So i am stuck in gallery2 check box. if i uncheck any of the check box from gallery2 entire data get disappear from Gallery3 instead of the specific checkbox data.

    Attached are screenshot for reference where i have selected all the check box from gallery2 and all the data is visible. another screenshot where i have unchecked (B) check box from gallery2 and all the data get disappear from gallery3, Ideally only B1 should disappear.Screenshot.PNGScreenshot1.PNG 

    Adding Addition information 

    Gallery 2 Check box properties are 

    Onselect - If(Checkbox2_5.Value,Collect(Lever , ThisItem.SolutionImpactLever),Clear(Lever))

    Oncheck - Collect(Lever,LookUp(Lever,Gallery1_2.Selected.Checkbox2_5.Value))

    OnUncheck - Remove(Lever,LookUp(Lever,Gallery1_2.Selected.Checkbox2_5.Value))

     

    Gallery 3 Items Property 

    GroupBy(Filter('ABC','Root Causes' in Root_Map , ' Solution Impact Lever' in Lever),"Solution","Data")

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @aayaanmayank ,

     

    Because you added Clear to OnSelect property, the collection is cleared every time a user unchecks an item. Using the below will allow you to only use the Onselect property and you can leave the OnCheck and OnUncheck properties blank:

     

    ClearCollect(Lever, Filter(Gallery2.AllItems, Checkbox2_5.Value))

     

  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    I did as you advised Keep the check and uncheck blank and on select property  update the same but updated but now gallery3 is not showing any dataScreenshot1.PNG

  • Verified answer
    BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @aayaanmayank ,

     

    Indeed you need to select the SolutionImpactLever column:

    ClearCollect(Lever, Filter(Gallery2.AllItems, Checkbox2_5.Value).SolutionImpactLever)

     

  • aayaanmayank Profile Picture
    aayaanmayank 248 on at

    @BCBuizer  You are CHAMPION 🙂, It is working the way i need

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

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