List CDS - expand query

[troyhoskison]

I am trying to create a email from CDS Data

However I need data from a related table so I added the lookupfield in the expand  query

When I go to the HTML table section I can see the field:-

So while editing it seems to work

but when I run it I get:-

But this is the right field:

Any help would be apreciated

Troy

[JatinSanghvi · Accepted solution]

Hi @troyhoskison , can you recheck if 'cr318_stockcodelookup' is indeed the navigation property name? You can check the CDS organization metadata by opening '<organization-url>/api/data/v9.0/$metadata' on browser and confirm if the string shows as name of the NavigationProperty element.

[Mira_Ghaly]

@troyhoskison 

Can you please show the full configuration of the List Records action?

[troyhoskison]

It looks like it was case sensitive