cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Nintex Newbie

Re: lookup() function using people

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

0 Kudos
Reply
Highlighted
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