cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akosila
Helper I
Helper I

Cascading checkbox gallery

I am following a video tutorial by  @Mr-Dang-MSFT  that shows a gallery within a gallery

I used this approach as a cascading checkbox wherein a parent can have multiple children

 

Now my question is if there is no child, it still shows a checkbox with no value (just a textbox). and when I check the Gallery.AllItems count, it shows 1 instead of zero.

 

How can I fix this?

4 REPLIES 4
v-yutliu-msft
Community Support
Community Support

Hi @akosila ,

Could you show me the link of the video tutorial by  @Mr-Dang-MSFT  that shows a gallery within a gallery?

Just based on your description, I can not understand this problem very good.

Maybe you could try this:

Set the checkbox's Visible:

If(CountRows(Gallery1.AllItems)=0,false,true)

Then when the situation that you descripted appears, the check box will disappear.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yutliu-msft 

 

Heres the link https://www.youtube.com/watch?v=IjiZDVHAnZo

 

I already did what you suggested to count the rows but it is returning 1 instead of zero, so it still shows. The CountRows is correct if there sub items. so if there is one sub item, then CountRows(Gallery1.AllItems) returns 1.

gallerysubgallery.png

Hi @akosila,

It sounds like you are encountering an issue involving checkboxes and nested galleries.

 

This is what I understand:

  • You have one gallery nested in another
  • You have checkboxes in both the child and parent galleries.
  • The parent gallery's checkbox affects the visibility of the child gallery

 

Can you describe your scenario a little more with some screenshots when things go wrong? 

Hi @Mr-Dang-MSFT  thanks for your question. 

 

Yes, I have a gallery within a gallery, just like in your youtube video

I have a checkbox inside the gallery just like in the attached image

gallerysubgallery.png

 

I just crossed out the text. The items have this grand parent-parent-child relationship

the grand parent is a dropdown - DropdownGParent
parent is a gallery- galleryParent
child is a gallery - galleryChild

DropdownGParent

Items: Distinct(colAllItems, Title) //colAllItems comes from a single sharepoint list that contains Title (for Grand parent, Parent, Child)

galleryParent
Items:
 GroupBy(Filter(colAllItems, Title = DropdownGParent.Selected.Result), "Parent", "GroupedByParent")
Inside galleryParent is a checkbox (CheckBox1) - Text: ThisItem.Parent

galleryChild
Items: Distinct(GroupedByParent, Child)

Visible: CheckBox1.Value //as per your video, gallery will show when the checkbox is checked

Inside galleryChild is a checkbox (CheckBox2) - Text: ThisItem.Result 


Now my problem is there are grandparents who do not have a parent items ; and some parents do not have child item/s.

But in my case, let's take the galleryParent and galleryChild as an example, the galleryChild and CheckBox2 still shows if the parent has no  child (see my screenshot above). 

 

let me know if you need more explanation.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,185)