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
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]
What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.
Datasource is Dynamics365 CRM
@timl wrote:Hi @UmairAhmedWhat data source are you using for your app? If it's SQL Server, you could use a View to simplify this.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand