cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
UmairAhmed
Level: Powered On

Power App filter List based on Grand Parent ID

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

3 REPLIES 3
UmairAhmed
Level: Powered On

Re: Power App filter List based on Grand Parent ID

I have tried this: 

First I filter Direct Child 

ClearCollect(BuildingAppartments,Filter(AppartmentsAppartmentID = 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]

 

 

 

Super User
Super User

Re: Power App filter List based on Grand Parent ID

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
Level: Powered On

Re: Power App filter List based on Grand Parent ID

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.


 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Users online (5,539)