Answered

Show display name instead of ID with lookup on dataverse

(0) Share

Report

Posted on by FGRODRIGUEZ

129

Hi, so I'm making an app on canvas and I'm using a data table to show data that is stored on dataverse table, the dataverse table has a lookup on two columns that brings and employee ID and a group that employee belongs to, the information shows on the table but for this 2 lookup columns it shows the ID instead of the display name, how would I correct that?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@FGRODRIGUEZ

You cannot use a datatable to do what you are asking. Instead, use a gallery with the labels placed horizontally to resemble a datatable, For the lookup fields labels use ThisItem.Asignado.LastName and ThisItem.Asignado.Groupname and let intellesense help you find the appropriate column names.

You can still use your datatable, just filter it on a dummy name to preserve the column names and put it over your gallery.

Was this reply helpful? Yes No
FGRODRIGUEZ 129 on at

Like (0)

Report

Thank you so much!, with this I was able to make it work!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@FGRODRIGUEZ You are very welcome!

Was this reply helpful? Yes No