I have issues retrieving a person stored in one column based on the value (person) in another by workflow (SPD2010) The real scenario looks like this:
- In the first list we store name of the team member (people picker field).
- When the item is stored, the mail should be send to a Team Lead. Information about who is whose Team Leader is stored in another list in a form Team Member - Team Leader (two separate columns)
- My approach was to bind a workflow on a create action and depending on the value from the originating item (first list) send an email to a person who is set as a current Team Lead in the second list.
The issue is - lookup action seems to not returning anything (it simply sends e-mail with empty "To" field).
I tried changing "Return field as" to different values - Display Name, Login Name, User Id - but with no success.
The question would be, of course, how can I in SharePoint Designer 2010 in Workflow query a person column based on an another person column from different list?