Solved

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

Posted on 2013-01-03
8
6,435 Views
Last Modified: 2013-01-10
Hi,
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 !
0
Comment
Question by:sharepointDepot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
8 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 125 total points
ID: 38742292
Hello,

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:

http://geekswithblogs.net/JayantSharma/archive/2012/07/26/lookup-for-person-or-group-column-in-sharepoint-2012.aspx

cheers, teylyn
0
 

Author Comment

by:sharepointDepot
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.
0
 
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Author Comment

by:sharepointDepot
ID: 38750040
It is not valid,
So the approach or link mention is not give any reference !
0
 
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
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

751 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