News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Using lookup column on...

Power Apps - Building Power Apps

Suggested answer

Using lookup column on Modern Data Table

(0) Share

Report

Report

Posted on by CU15102336-0

2

I am trying to use the modern data table control in Power Apps, but I have an issue.

In my Dataverse Table, I have a Lookup-type column, which by default shows me the column (ID_RL). However, I need to display the "norma" column.

By default, the data table loads the query in the FieldName field with the query "crb4b_Requisito_Legal".

I tried modifying it in the following ways without success:

1. crb4b_Requisito_Legal.norma 2.ThisItem.Requisito_Legal.Norma

How could I display the column I need and not the default column?

Categories:

Using Apps Using Formulas

Captura de pantal...

All responses Img

All responses (2)

Answers Img

Answers (0)

CU15102336-0 2 on at

Like (0)

Report

Using lookup column on Modern Data Table

tks
Nandit,

This worked partially. In the table, I now have the option to include the column I want, but this affected a form I use to input or display the table's information, where I have the items defined as: Table3.Selected

which is the table in which we modified the query as you suggested. It seems the lookup relationship or something similar is being lost.

I put the info of the table3.selected in a variable the result is show in the image.
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Using lookup column on Modern Data Table

Hi CU15102336-0,

Assuming you are trying to display, in the table control, a different column from a related Dataverse table using the default lookup column.

Here's how you can do it, modify and paste the below code in Table Items property:

With( {Records: DataverseTable}, AddColumns( Records, NewColumnName, DefaultLookUpColumn.RequiredColumn ) )

It works for me, hope it works you.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!