I have one list called Teams. The Teams item has two columns Leader and Members. Both are people fields with the Members being multiple values.
I have a second list called Requests. In a Requests Sharepoint designer workflow, I want to lookup the creator of the item against the Members column of the Teams list and set the Leader field on Requests to the value returned in the Leader column in Teams list.
I can't even get the lookup to work let alone setting the Leader people column in requests.
Can anyone tell me how I can lookup a person in another list against a people column with multiple values? Is it even possible?
We are using SharePoint 2013 but only 2010 workflows are enabled.