{"id":249,"date":"2010-05-07T17:32:10","date_gmt":"2010-05-07T15:32:10","guid":{"rendered":"http:\/\/www.itidea.nl\/wordpress\/?p=249"},"modified":"2015-09-08T20:32:52","modified_gmt":"2015-09-08T18:32:52","slug":"programmatically-change-the-value-of-a-lookup-column","status":"publish","type":"post","link":"https:\/\/www.itidea.nl\/index.php\/programmatically-change-the-value-of-a-lookup-column\/","title":{"rendered":"Programmatically change the value of a lookup column"},"content":{"rendered":"

Lookup values are internally referenced as a combination of ID(int) and field value(string) in the following format: 1;#FirstItem.
\nThe class offered by SharePoint for lookup values is SPFieldLookupValue. The method SPFieldLookupValue takes 1 or 2 values:<\/p>\n

    \n
  1. \u201c1;#FirstItem\u201d (string)<\/li>\n
  2. lookupId and lookupValue. Obviously the lookupId represents the field\u2019s ID, lookupValue represents the field\u2019s value.<\/li>\n<\/ol>\n

    Obviously you have to know the ID and value of the new item to set to the lookup field.
    \nTo enumerate all the possible items of the lookup list:<\/p>\n

    string itemsListed = string.Empty;
    \nSPListItemCollection sources = web.Lists[“Source”].Items;
    \nforeach (SPListItem item in sources)
    \n{
    \n\u00a0\u00a0\u00a0 itemsListed += item[“ID”].ToString() + “;#” + item[“Title”].ToString() + System.Environment.NewLine;
    \n}<\/p>\n

    An example of the content of itemsListed:
    \n1;#FirstItem
    \n2;#SecondItem
    \n3;#ThirdItem<\/p>\n

    To search for a specific item you can use a CAML query:<\/p>\n

    SPQuery query = new SPQuery();
    \nstring toSearchFor = “ThirdItem”;
    \nquery.Query = “<Where><Eq><FieldRef Name=’Title’ \/><Value Type=’Text’>” + toSearchFor + “<\/Value><\/Eq><\/Where>”;
    \nSPListItemCollection collection = web.Lists[“Source”].GetItems(query);
    \nIf(collection.Count == 1)
    \n{
    \n\u00a0\u00a0\u00a0 int idOfItem = int.Parse(collection[0][“ID”].ToString());
    \n\u00a0\u00a0\u00a0 string totalLookup = idOfItem.ToString() + “;#” + toSearchFor;
    \n}<\/p>\n","protected":false},"excerpt":{"rendered":"

    Lookup values are internally referenced as a combination of ID(int) and field value(string) in the following format: 1;#FirstItem. The class offered by SharePoint for lookup values is SPFieldLookupValue. The method SPFieldLookupValue takes 1 or 2 values: \u201c1;#FirstItem\u201d (string) lookupId and … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[13],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2007","tag-moss-2007"],"_links":{"self":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":1,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":250,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions\/250"}],"wp:attachment":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}