Hello all,
I have two lists.
List 1 contains the columns: Country and building code.
List 2 contains columns: UserName and building code.
On both lists, the building code column contains the same data.
I want to use a gallery to lookup what country has been selected in the first gallery using the building codes that exists in both lists.
I am able to do this within the same list, but doing it across two lists eludes me.
For the one that I got working, the first gallery's ITEM is set to Sort(Distinct('List1', Country), Ascending)
The second gallery that looks at the building codes and then gives me a list of buildings per country's ITEM is set to Filter('List1', Country=Gallery7.Selected.Result, StartsWith(City, TextInput3_1))
It works beautifully, but I need to use the second list to be able to check against the county, using the building code that is the same as the first list and show me the UserName per country.
I hope that made sense.
I'd appreciate any input.
Cheers
JD
