web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

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?

Captura de pantalla 2024-10-15 184525.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
CU15102336-0 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation