Hi,
I have a Table 1 with has 1:N relationship to Table 2 (table containing owners for records in Table 1) which is a lookup to user table.
Table 1 -> Table 2 -> User.
Now in a gallery whose source is table 1. I want to see all owners mapped to the record from table 1.
In a text box inside gallery I am using the the formula:
Concat(ThisItem.RelationshipName (fromTable1),Table2LookUpColumn.'Full Name',"_;")
This formula gives me 5 _; (_;_;_;_;_;) since there are 5 users linked to record in table 1 but doesn't give me the user names for the same.
Any leads or suggestions on how to solve this would be appreciated.
