Power Platform Community Forum Thread Details

Hi All,

I'm struggling with some data that i currently have set up as parent/child, vertical and horizontal nested Galleries. the issue I'm having is that I'm not good enough at PowerApps to work out how to filter the data in the child/nested gallery. (i've now spent countless hours trying to work this out!)

As I've been looking at this though, i'm wondering if my current setup is overcomplicated and i'm wondering if i can do away with these parent/child galleries and instead just create a collection and work from that.

I have a SharePoint list called "Materials list" - This in its current form has thousands of records and in this materials list each product has a Unique Column titled "ItemRef". (Other columns include, "Product", "Category", "Price" etc. etc.)

We only offer certain items to certain clients so for each client with have a separate sharepoint list called "ExtrasOffered" which has only one column and this column is also titled "ItemRef" and this is a relation to the MaterialsList "ItemRef"

What i'm wanting to do is create a collection called "MaterialsListExtras" and in this filter the materials list so that the Collection only shows the records from the MaterialsList where the ItemRef is present in the "ExtrasOffered" list .ItemRef.

I have tried using Filters and Lookups etc, but what seems to be a simple task has caused me a great deal of frustration. I'm possibly just missing out on something really simple, but would be happy if someone could please take a look and point me in the right direction.

I believe the picture i have attached might explain the issue i'm having better than my writing so please find that attached. (my actual data has quite a few more columns, but i've just tried to simplify to hopefully make it easier to understand)

Alternatively, if the only way to do this is with the parent/child nested galleries, could anyone point me in the direction of any training resources where i might learn how to filter the child data.

Create a collection by Filtering Multiple values in a table.jpg