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

Report
All responses (
Answers (