Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7193
  • Last Modified:

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

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
sharepointDepot
Asked:
sharepointDepot
  • 4
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
sharepointDepotAuthor Commented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Sorry, hit the wrong button above. This is meant to be an objection to the delete request
0
 
sharepointDepotAuthor Commented:
It is not valid,
So the approach or link mention is not give any reference !
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now