AnsweredAssumed Answered

lookup() function using people

Question asked by rangerdan94 on Aug 1, 2018
Latest reply on Aug 3, 2018 by emha

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.