You’re offline. This is a read only version of the page.
9
Hi,
I have a gallery connected to a D365 table (Questionaires). This entity has a lookup field of type User called Checker.
As I need to sort on this field, I am trying to add a column to the gallery to show the Checkers full name.
My issue is that no matter how I define it, my added column is always empty 😞
for thegallery items source I have tried both..
AddColumns(Questionaires,"CheckerName",LookUp(Users, User=Checker.User).'Full Name')
and
AddColumns(Questionaires,"CheckerName",LookUp(Users, User=Checker.User, 'Full Name'))
and my column text in the gallery is
ThisItem.CheckerName
Any help appreciated 🙂
All other columns in the gallery are populated correctly, but the added column is empty.
Regards
Chris Adams
Hi,
In case anybody else faces this issue, I resolved it by casting the User explicitly as Guid like this
AddColumns(Questionaires,"CheckerName",LookUp(Users, User=Guid(Checker.User)).'Full Name'
🙂
Share
Report
All responses (
Answers (
