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
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]
Hi @UmairAhmed
What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.
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.
Hi Umair
I've got the same issue and was wondering if you ever got this resolved? Is it at all possible to do this?
Cheers!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
200 | |
70 | |
51 | |
47 | |
20 |
User | Count |
---|---|
256 | |
120 | |
85 | |
80 | |
68 |