Double JoinFieldValue
I am trying to get the "Role" of the of a user.
I have a Rep that "Reports to" Bob.
Bob's "Role" in CRM is District manager
So I tried an expression like this:
JoinFieldValue('<User>',JoinFieldValue('<User>', [<OwnerId>], '<Role>'),'<ManagerFullName>')
I am not getting a syntax error but it is not returning the Role either. Actually, it's not returning any value at all.
I have switched the Role and ManagerFullName position and it did not make a difference.
Any suggections would be appreciated.
Cheers,
GH