Announcements
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?
@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.
Thank you so much!, with this I was able to make it work!
@FGRODRIGUEZ You are very welcome!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 355 Most Valuable Professional
11manish 209 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2