Hello Power Apps Community,
I hope you can help please with a canvas app issue I'm having.
I have three CDS entities: "Office Space", "Token" and "Booking". They use one-to-many relationships.
I can have one "Office Space" which has many "Tokens", and I can have one "Token" which has many "Bookings".
I have a gallery that's data source is "Booking".
On each record I want to display three pieces of data:
Solved! Go to Solution.
Hi @GarryPope ,
It's not SUPPORTED to reference multiple level of relationship directly by double dot notation.
First to use LookUp formula to obtain the LookUp field value of Token Entity, and use Dot Notation to reference Office Space Name from the related record.
Please try with this.
LookUp(Tokens, Token = ThisItem.'LookUpFieldofBookingEntity'.Token, 'LookUpFieldofTokenEntity').'Office Space Name'
//I assume the Token is the GUID field of Tokens Entity, and then replace that two LookUp field.
For example: Reference the Full Name from GrandParent Entity-User.
Hope this helps.
Sik
Hi @GarryPope ,
It's not SUPPORTED to reference multiple level of relationship directly by double dot notation.
First to use LookUp formula to obtain the LookUp field value of Token Entity, and use Dot Notation to reference Office Space Name from the related record.
Please try with this.
LookUp(Tokens, Token = ThisItem.'LookUpFieldofBookingEntity'.Token, 'LookUpFieldofTokenEntity').'Office Space Name'
//I assume the Token is the GUID field of Tokens Entity, and then replace that two LookUp field.
For example: Reference the Full Name from GrandParent Entity-User.
Hope this helps.
Sik
User | Count |
---|---|
24 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
26 | |
10 | |
9 | |
8 | |
7 |