Unanswered

Modern Table - How to display foreign (related) fields

(1) Share

Report

Posted on by SB-24090026-0

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @SB-24090026-0

It would be Dot Notation

So ThisItem.LookUp.Record.Property

or depending on what it is it could just be

ThisItem.LookUp.Property (from the related table)

Meaning you dont "find" it as a selectable column, you have to use Dot Notation to drill down to it.

Was this reply helpful? Yes No
SB-24090026-0 21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Michael E. Gernaey,

The dot notation does not work in a modern table control. When inserting a modern table, there is a button to see all the columns and it only lists columns from the primary table, including the name of the related table. If you select a column to add to the table, it creates a new table column object and sets its FieldName attribute to the name of the field as a string. I tried modifying the FieldName string with dot notation but that produces an error when fetching the records.

When displaying all the fields in the table, it does show my related table name but only allows me to select the related table, which then returns the primary display (name) column from the related table and does not allow me to specify other columns.

Using the monitor, I can see that the Dataverse fetch is retrieving all the related fields in the query but there is no way to access them. If I put the dot notation in Field Name (e.g., "Departments.city"), it will generate an error as the $select being sent to Dataverse is asking for Departments.city which obviously is not a column name on the base table.

I did just get AddColumns to work. Just have to make sure to convert fields to Text (e.g., Text(Departments.city), or in the Field object inside the table, set FieldType attribute to "d" (no documentation on FieldType but figured this out).

Was this reply helpful? Yes No