1

I have two different list. In the first list are some people picker columns. Is it possible to create a lookup column for list 2 to add the user from the first list? I know it isn't supported in Sharepoint, but i hope someone have an idea to solve my problem.

1 Answer 1

4

Directly the "People Picker" column will not be supported as a lookup in another list. For this scenario, you can create another column of "single line of text" type. Then by using a simple workflow you can update the newly created column with the value from "People Picker column" (Workflow should be triggered on new item added/modified).

Now you can refer the newly created column as a lookup column in any other list.

1
  • That's a very good solution. The only problem is that the workflow creates a new version of my item. Is it possible to stop creating a new version if you use a workflow? I have 5 or 6 "people picker" in my list and the Workflow starts when one this columns are be changed. so it could be possible that my "wokrlfow copy" of the peoaple picker creates 5 o6 versions of my item.
    – Tiac
    Commented Oct 7, 2013 at 7:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.