Cant display/access related contact record in DataTable with CDS

[OctavioDlg]

Hello,

I have two collections that I create on the OnVisible property of the screen, one storing a contact record and another an account record:
Creation of Collections

I populate two different DataTables with these collections, however Im not able to display the primarycontactid or any other lookup field:
Main Screen

This is how I set the data source to each DataTable:

Contacts

Contacts

Accounts

Accounts

The account and contact record are related, but not sure why I cant see data of the contact record in the Account DataTable:

Anyone has faced a similar issue?

Thanks!

Octavio

[WarrenBelz]

Hi @OctavioDlg 

Your syntax looks correct.

I know this is obvious, but have you checked that the record you refer to has data in that field?

ClearCollect(
   colContacts,
   Filter(
      Contacts,
      Contact = GUID("25al7064-lae7-e611-80f4-e0071b661f01M")
   )
); 
ClearCollect(
   colAccounts,
   Filter(
      Accounts,
      Account = GUID("d96b3f4b-lbe7-e611-8101-e0071b6af231M")
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-siky-msft · Accepted solution]

Hi @OctavioDlg ,

I can reproduce your issue and just find the workaround. This may be a connection issue between two entity, please try to use AddColumns function to save a Value of lookup field to a new Column, this process will trigger a call to the related entity, and then the LookUp field can be shown properly.

Set Items property of Table as below:

AddColumns(Filter(Accounts,Account=GUID("f754e2ed-beb0-e911-a9c8-0022480081c3")),"Column1",'Primary Contact'.'Full Name')

Hope this helps.

Sik

[OctavioDlg]

Awesome!

Thanks