Nested Filter in Galleries linked to father gallery

[Corleone]

Hi all,

question about filtering a gallery nested within a gallery. 

I am using one list and one library on my SharePoint:

Library "Defects", where I have:

• "ItemID" (Single Line of text)

List "Monitorization", where I have:

• defectID (lookup to column "ItemID" from my "Defects")

In my App, my galleries are distributed like this:

- Gallery 1, Father´s gallery -> linked to "Defects"

- Gallery 2, Child´s gallery -> linked to "Monitorization"

My objective is: my Gallery 2 to show only the items from "Monitorization" that "defectID" match with "ItemID" from my gallery 1 "Defects".

for that, on Items property:

Filter('Monitorization', defectID = ThisItem.ItemID)

but ERROR APPEAR => Invalid argument type. Gallery2 .Items

Hope make sense.

thanks a lot your time and support! 🙂

[gabibalaban · Accepted solution]

hi @Corleone ,

If defectID is a lookup column, use:

Filter('Monitorization', defectID.Value = ThisItem.ItemID)

Hope it helps !