Answered

Filtering a Nested Gallery

(0) Share

Report

Posted on by d3ell

276

Hi,

I have a vertical gallery with a horizontal nested gallery inside (the Horizontal nested gallery is filled in pink in the picture below)

the Common ID is the BELREF.

I would like to filter the gallery by the 'Category' in the child's nested gallery.

I've spent a while and not come up with anything that works.

I have 2 collections - one called SupplierMaterials, which is a long list of materials, however i am only wanting to show the records from this list where the BELREF is found in a collection called ExtrasItems.

The Parent/Child relationship seems to work fine, but i cant filter it how i would like too. - Is this even possible??

In the picture below and attached i have labelled what the items properties of the Galleries are set too and tried to show where the nested galleries fit.

The ideal scenario here is when "EXTERNAL" is Selected in the CategoryDD dropdown that i would only see the top 2 items.

Any ideas anyone?

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

KennethNicasens on at

Like
a
(2)

Report
Copy link

Link copied!
Can you use the following fx in the Items property of the sub-gallery:
Filter(SupplierMaterials,BELREF = Text(ThisItem.BELREF), CategoryDD.Selected.Text = CATEGORY)
This will filter your gallery on belref as well as on category selected in the dropdown.
Now you will still have some parent records without child records. This can be solved by adding a filter on the parent gallery item property:
Filter(ExtrasItems As ParentTable, CountIf(SupplierMaterials,BELREF = Text(ParentTable.BELREF),CategoryDD.Selected.Text = Category)>0)
Something Like this should work! (Maybe the names of the objects are not the same as yours)

Was this reply helpful? Yes No
d3ell 276 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, That worked pretty much as a simple copy and paste exercise, Just my DD box needed to have .Value rather than .Text and it worked perfectly!!
I'm new to working with Parent/Child relationships and its become a bit of a necessity so you help will go a long way very much appreciated.

One thing i was hoping to get from the reply was that i would be able to understand whats happening, but i dont at the minute so going to try and learn whats going off there.

Would you be able to help me with one other little thing? (sorry to be cheeky!)

The ContractorDD i would ideally like its items property to be a DISTINCT version of all the Child Items in the gallery. So in the previous example if that was all the items the only two items that would appear in the dropdown box would be "External" & "Lighting". However if there was a child item with another category that would show up in there too?

Thanks Again. 😀

Was this reply helpful? Yes No
d3ell 276 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KennethNicasens would you be so kind as to have a look at my query regarding filtering the Dropbox by DISTINCT on all the child data. I have had lots of attempts and came up with nothing. 😖

TIA

Was this reply helpful? Yes No
KennethNicasens on at

Like
a
(0)

Report
Copy link

Link copied!

HI!

That will be dificcult because you are using the dropdown to filter as well.
A solution to that would be to have the result of the sippliersmaterials collected in a collection and build your dropdown based on that collection.

Was this reply helpful? Yes No