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:
- Booking Name. This is from the Booking entity. - So this can be achieved using this expression in the Text property of a label: ThisItem.'Booking Name'
- Token Date. This is from the Token entity. Which is the parent of Booking. - So this can be achieved using this expression in the Text property of a label: ThisItem.Token.'Token Date'
- Office Space Name. This is from the Office Space entity. Which is the parent of Token. - This is where I'm having trouble, as I am unable to present this value. I believe I need to use a lookup in my expression, but am unable to achieve this.
If anyone can help and explain how I look up two entity levels above and show the data that would be great.
Thanks very much,
Garry
