Power App filter List based on Grand Parent ID

[UmairAhmed]

Hi experts,

I would appreciate your help in solving my problem:

I have three tables Building, Appartment, Residents and I have to Filter Residents based on selection of Building and I have to display Residents with Appartment name.     

Building Table has ( BuildingName, BuildingID)

Appartment Table has (AppartmentName, AppartmentID , BuildingID)

Resident has (ResidentName, AppartmentID, DOB, Gender)  

Building has one to many relation with Appartment 

Appartment has one to many relation with Resident  

I want to display  Resident Name, AppartmentName in the List.   I would appreciate your suggestion to solve this. I tried using ClearCollect with Lookups but could n`t able to work out.  

Regards, Umair Ahmed

[UmairAhmed]

I have tried this: 

First I filter Direct Child 

ClearCollect(BuildingAppartments,Filter(Appartments,  AppartmentID = BuildingGallery.Selected.BuildingID));

Then for the Grant child I am trying below

ClearCollect(ResidentAppartment,"Resident",LookUp(Residents,AppartmentID= BuildingAppartments[@AppartmentID] ))

I get below errors

Invalid ArgumentType on "="   

Delegation warning on BuildingAppartments[@AppartmentID]

[timl]

Hi @UmairAhmed

What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.

[UmairAhmed]

Hi @timl,

Datasource is Dynamics365 CRM

---

@timl wrote:

Hi @UmairAhmed

What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.

---