Hello Folks. I'm new to this board and I'm sure this topic has been discussed, so I apologize, but I couldn't find the answer I was looking for. My issue is I have a gallery where I need to display Name from the Contacts table and Worksite Name from the Worksite table via WorksiteID. There is already a SortByColumns function in the Items property. Is there a way to make this happen? FYI, I do not need edit either of these fields and I've tried the following in the Text property of the worksite label:
LookUp(
Worksites,
'id-ID' = ThisItem.NewWorksite
).'Worksite Name'
