I have a table called "Requests" with a person field called [Requester].
I have a second table called "Employees" with a person field called [Employee] and another field called [Team].
The fields on my form are named the same.
On my Nintex form, Requester is a people picker. Once the person is selected, I would like to do a Lookup on the Employees table to pick up the Team.
I tried to use this Calculated Value -- lookup("Employees","Employee",Requester,"Team"), but I just get a blank.
Does anyone have any idea how to do this?
P.S. The team name stored in the table is not available in the userprofile.