AnsweredAssumed Answered

Can I lookup a person in a table based on a people picker drop down?

Question asked by sshaffer on Feb 21, 2018
Latest reply on Apr 13, 2018 by emha

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.

Outcomes