Is it possible to make a lookup column that looks up “Person or Group” type from another list?

Question

I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my source list only consist of Dates or Text types. The column I want to pull is of type Person or Group. I read that this might not be allowed, since it is like doing a "Lookup of a Lookup". Is there any way around this?

Answer 1

There is no way you can do this OOTB in SharePoint. So you have to do some coding to get your solution.

Here is a sample code which performs the operation you want.

     /// <summary>
    /// Create LookUp Column in Site Columns
    /// </summary>
    /// <param name="fieldName">LookUp Field Name</param>
    /// <param name="fieldTitle">LookUp Field Title</param>
    /// <param name="required">Field Required or Not</param>
    /// <param name="allowMultipleValues">Multiple Allowed or Not</param>
    /// <param name="sourceList">Source List of LookUp Column</param>
    /// <param name="destinationlist">Destination List of LookUp Column</param>
   /// <param name="sourceField">Source Field of LookUp</param>

    public static void CreateLookupField(string fieldName, string fieldTitle, bool required, bool allowMultipleValues, SPList sourceList, SPList destinationlist, string sourceField)
        {            
            try
            {
                destinationlist.Fields.AddLookup(fieldName, sourceList.ID, required);
                SPFieldLookup lookUpField = (SPFieldLookup)destinationlist.Fields[fieldName];
                lookUpField.AllowMultipleValues = allowMultipleValues;
                lookUpField.Title = fieldTitle;
                lookUpField.LookupField = sourceField;
                lookUpField.Update(true);
                destinationlist.Update();
            }
            catch (Exception ex)
            {

            }            
        }

If you have any doubt in this code then ask me.

Answer 2

And how can I get the value (SPuser or SPgroup) of the "users and group" field from my lookup to my second list?