Modern Table - How to display foreign (related) fields

I have two Dataverse tables that are related but am unable to figure out how to display fields from a related table in the Modern Table control.

Example:

Table User:

- Full Name

- Department (as GUID)

Table Department:

- Department (as GUID)

- Name

- Department City

I need to be able to display the User Full Name and Department City as columns in the same Modern Table. For Items I specify the User table. Looking at the Fields list in the Table, the Department is shown as a linked (lookup) field and if I select it, the table shows the default column (name). How do I add the Department City as a column in the table? I have been trying different things like AddColumns to the Item which resulted in weird behavior and never what I wanted. Not sure if there are problems accessing the related fields in the table control due to this being in preview, or I am taking the wrong approach.

Categories:

General Questions