Cannot retrieve specific property from a lookup field in a canvas app.

[Anonymous]

I am trying to build my first canvas app here! Need some help with the lookup fields in the displaying forms. I have a registration screen where I populate one entity that has a lookup field in another entity. 

Then I try to show the info in a display form. In the lookup field datacard in the "DefaultSelectedItems", I use the table function because I found out that the lookup field is stored in a combobox. 

Table({ key: ThisItem.cr32f_DeviceType.cr32f_devicetypeid })

Here the "cr32f_DeviceType" is the lookup field and I can indeed display the devicetypeid correctly(screenshot attached), but when I  try to display other properties of the entity it returns 'blank'.

When I check the data of the Entity Row in the database it shows all the values for the lookup.
However, in the app it is 'blank'.  
Any thoughts on this? 

[PowerAddict · Accepted solution]

If you go to File->Settings->Advanced Settings. Is the Explicit Column Setting set to true? If so, try to set it to false. 

Or, since you can fetch the ID, use a LookUp using the ID to fetch the complete record and then display the value you want to see. 

Let me know if this helps or if you need more details. 

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email