Problems with AddColumns on gallery

[Enphridian]

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

[Enphridian · Accepted solution]

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'

🙂