Dear all,
I'm struggling with a filtering problem for some time so I hope someone can help me out in the right direction!
I have created 3 sharepoint lists:
COUNTRY
CountryCode
Name
CITY
CityCode
Name
Country (lookup to country)
HOUSE
HouseNr
Name
City (lookup to city)
PowerApp issue:
In my first screen I have a gallery where I select the COUNTRY and navigate to a 2nd screen.
In the second screen now I want to show a gallery with all houses that belong to that selected country.
So this is what I'm trying to do, but it gives me errors.
Filter(House, City.Value in Filter(City, Country.Value = CountryGallery.Selected.CountryCode).CityCode)
CountryGallery is my country selector on the first screen.
Any ideas? Really appreciate your help!
Kind Regards
