Dynamics 365 CDS - Display lookup field in gallery

[binkster]

I've searched online but can't find a straighforward answer for this (and apologies as it's probably a pretty basic question!)

I'm using the CDS connector to work with Dynamics 365 data. 

How do you display lookup field in a gallery when using the CDS?

When I was using the Dynamics 365 connector, I would use the following syntax to display a lookup to an Account but this doesn't work with the CDS connector:

LookUp(Accounts,accountid=ThisItem._new_accountnameid_value,name)

What is the equivalent formula for the CDS connector?

[binkster · Accepted solution]

Resolved this myself after playing around with the formula. 

To display the lookup name in the gallery rather than the guid, use the following syntax:

ThisItem.'<Insert field Label of current entity>'.<Insert field label of entity being looked up to>'

In my instance I'm looking up to the Account entity from a custom entity where the field is called 'Site Name'

e.g.

ThisItem.'Site Name'.'Account Name'