how to lookup "person or Group"  field from other list

Posted on 2013-01-03
Medium Priority
Last Modified: 2013-01-10
I have 2 custom lists :
1st custom list with 3 columns: x(Text),y(Text),z(Person/group).
2nd list whch lookups all 3 columns from above list : lookup:x, lookup:y, ????
Is there any way to lookup col z which is "person or group" type.
Thanks in advance !
Question by:sharepointDepot
  • 4
  • 2
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 38742292

not out of the box, no. The person/group field is by definition already a lookup field (to the SharePoint user list) and cannot be used as the source for a lookup column.

You would need to create a regular lookup to a text field and then manipulate the code. I have not tried this, but here is an approach that may work:


cheers, teylyn

Author Comment

ID: 38743052
I've requested that this question be deleted for the following reason:

nope this question is under out of scope and correct approach.
the link suggested if of no clue.
LVL 50
ID: 38743046
I don't understand the wording for the request for deletion.

Out of the box it can't be done. That is a valid answer.
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

LVL 50
ID: 38743053
Sorry, hit the wrong button above. This is meant to be an objection to the delete request

Author Comment

ID: 38750040
It is not valid,
So the approach or link mention is not give any reference !
LVL 50
ID: 38750079
OK, back to your original question

>> Is there any way to lookup col z which is "person or group" type.

Answer: No, that cannot be done.

Even if you don't like the answer or it does not solve your issue, it is a valid answer and deserves to be closed properly.

cheers, teylyn

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question