Adding a Lookup Column to a SharePoint List

by Posted on

This took me a heckuva lot longer to get working right than I will ever admit. I thought the end result was nice and tidy. This example shows how to take a list from one web, and populate a column in another list based on the values from the first. Modifications to the first list will be reflected in any columns that reference that list via lookup.

SPSecurity.RunWithElevatedPrivileges(delegate()
{
    using (SPSite website = new SPSite(SPContext.Current.Site.ID))
    {
        website.AllowUnsafeUpdates = true;                  

        SPWeb newWeb = website.OpenWeb(_newWeb.ID);
        newWeb.AllowUnsafeUpdates = true;

        #region Add Lookup Column to new doc lib
        SPDocumentLibrary newDocLib = (SPDocumentLibrary)newWeb.Lists["Documents"];

        // Grab list guid and the web container
        Guid customListGuid = ListManager.GetGuid(SPContext.Current.Web, “MyCustomWebList”);

        newCRFDocLib.Fields.AddLookup(”Some Descriptive Field Name”, customListGuid, SPContext.Current.Web.ID, false);

        // Add the new lookup field to the default view.
        SPField fld = newCRFDocLib.Fields["Some Descriptive Field Name"];
        SPView defaultView = newCRFDocLib.DefaultView;
        SPViewFieldCollection viewFields = defaultView.ViewFields;

        viewFields.Add(”Some Descriptive Field Name”);
        defaultView.Update();

        ListManager.ReorderField(newWeb.Lists["Documents"], fld, 0);
    }
}       

public static Guid GetGuid(SPWeb web, String listName)
{
    foreach (SPList list in web.Lists)
    {
        if (true == list.Title.Equals(listName, StringComparison.OrdinalIgnoreCase))
            return list.ID;
    }
    return Guid.Empty;
}

Published by MichaelKB

524 Replies to “Adding a Lookup Column to a SharePoint List”

  244. When I read an article on this topic, slotsite the first thought was profound and difficult, and I wondered if others could understand.. My site has a discussion board for articles and photos similar to this topic. Could you please visit me when you have time to discuss this topic?

    Reply

  383. wonderful points altogether, you simply won a new reader.
    What could you suggest in regards to your post that you made a few days ago?
    Any sure?

    Reply

  391. Undeniably imagine that which you said. Your favourite reason seemed to be at the net the simplest thing to
    be mindful of. I say to you, I definitely get annoyed even as other folks consider worries that they just
    do not realize about. You managed to hit the nail upon the top and defined out
    the whole thing without having side effect , other folks could take a signal.
    Will likely be again to get more. Thanks

    Reply

  482. Howdy! [url=https://onlinepspharmacy.top/#online-pet-pharmacy]tramadol pharmacy online[/url] very good website.
    [url=https://onlinepspharmacy.top/#]qke[/url]

    Reply

  486. Regards. Ample write ups!
    french essay writing service [url=https://writinganessaycollegeservice.com/]will writing service weston super mare[/url] essay writing service freelance [url=https://essayservicehelp.com/]essay writing service review[/url] best ielts writing correction service cheap college essay writing service [url=https://argumentativethesis.com/]research thesis[/url] phd thesis writing services [url=https://bestmasterthesiswritingservice.com/]thesis statement.[/url] thesis statement about friendship

    Reply

  489. You said that really well!
    essay writing service houston [url=https://domyhomeworkformecheap.com/]idk how to do my homework[/url] do my physics homework online [url=https://domycollegehomeworkforme.com/]how much should i pay someone to do my homework[/url] louanne johnson my posse don t do homework will writing service derby [url=https://dissertationwritingtops.com/]doctoral dissertation help[/url] my dissertation [url=https://helpwritingdissertation.com/]dissertation writing services review[/url] buy cheap dissertations

    Reply

  502. Howdy! [url=https://propeciasuperhair.online/#online-pharmacy-school]buy generic propecia[/url] beneficial internet site.
    [url=https://propeciasuperhair.online/#]iaj[/url]

    Reply

Leave a Reply

Your email address will not be published.