cancel
Showing results for 
Search instead for 
Did you mean: 
rangerdan94
Nintex Newbie

lookup() function using people

To start with, here is what I am trying to do: On a form, I want to lookup (from another list) and based on the currentuser, return another column, from that list.

Based on the currentuser, go out to an Approver list, and find that person's approver.

The Approver list has Employee (People), TravelApprover (People).

I'm trying to use a calculated Value with the following formula:

lookup('Approver','Employee','Employee', 'TravelApprover')

The second Employee in the function is a Named Control.

Nothing is being returned.  I must be missing something, I would think this would be pretty easy.

Tags (1)
0 Kudos
Reply
2 Replies
jpmhuls
Nintex Newbie

Re: lookup() function using people

2nd employee should not be in single quotes, only the Named Control reference.

0 Kudos
Reply
Automation Master
Automation Master

Re: lookup() function using people

note as well you have to provide employee value (3rd parameter)in a correct form.

have a look on this https://community.nintex.com/message/77277-re-can-i-lookup-a-person-in-a-table-based-on-a-people-pic... 

0 Kudos
Reply