Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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:

Labels: (1)
0 Kudos
1 Reply
Workflow Hero

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
Accept as Solution Reply