Power Platform Community Forum Thread Details

I have multiple tables all related. I am trying to filter a gallery to show all the results of a lookup field, where there may be multiple lookup fields results.

I have a collection with multiple GUID called collectionLocations. These are the GUIDs of a table called Location. I retrieve this GUIDs from various ways but that all works well.

I have another table called 'Session Registrations' which has a lookup field to the Location table called 'LU Location'.

I need to filter the 'Session Registrations' table to show all session registrations where my lookup field 'LU Location' is in the collectionLocations.

I have tried various options but the 'in' function returns nothing.

Filter('Session Registrations', 'LU Location'.Account in collectLocations)

If I try Filter('Session Registrations', 'LU Location'.Account = "1234-4321-1234-4321") then it works on that Location, but I need it to have multiple locations filtered.

I hope this all makes sense and any help appreciated.

Categories:

Building Power Apps