Design Dabbler

Lookup comparing Username

I have a form with a calculated value control, and want to use the lookup function to retreive the value from another SharePoint list. The value to compare would be the current user, and a people picker value on the second list. The results are returning #Value!

Calculated Value Control:

The control with the current user has the Item Property set to Name

Lookup List:

Returned Value:

0 Kudos
1 Reply
Workflow Veteran

Re: Lookup comparing Username

Hi, have you tried swapping "Name" and "CoWorker"? In the Lookup function, following the list title, you need to specify the column name to use as filter ("CoWorker") and then the filter value (Name, if all is well without the double quotes, but try anyway; if neither helps, use the Name inside a parseLookup function).

0 Kudos