PingBack from http://msdnrss.thecoderblogs.com/2007/08/25/update-quotlookupquot-fields-in-sharepoint-2007/

Hi Sridhar,

This is a good article and was the start point of a difficult problem I was in. But, I think there is another elegant way to do this, implementing SPFieldLookupValue and SPFieldLookupValueCollection objects.

You can also just use the id:

listItem["ProductLookUp"] = 5;

Hi,

I had a strange error where it worked... then didn't work (thought I was going crazy).

I was creating a file item in a document library and was also checking the file in (by default it was checking it out to me which was undesirable)

2 hrs of my life which I'll never have back later I found out it was because I was checking an item in AFTER the lookup whereas in the first attempt I'd checked it in before ;). For some reason this was overwriting the value so it always returned blank.

###### This was WRONG:  

myFile.Item["MyLookupField"] = new SPFieldLookupValue(3, "Product Name");

myFile.CheckIn("Checkin Message", SPCHeckinType.MajorCheckIn);

###### This was RIGHT:  

myFile.CheckIn("Checkin Message", SPCHeckinType.MajorCheckIn);

myFile.Item["MyLookupField"] = new SPFieldLookupValue(3, "Product Name");

Great Job Sridhar's

You also have different behavior with a multi-select lookup or a people field.

Ive written something about that here

http://apichot.blogspot.com/2007/06/sharepoint-2007-champs-lookup-et-people.html

Hi, thank you a lot Sridhar. You have solved my problem and saved enough time.

Hi Sridhar,

I have published an InfoPath form into a document library. I want to add items dynamically to it. I used your adding a new item code. But it generates following error:

To add an item to a document library, use SPFileCollection.Add()

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.SPException: To add an item to a document library, use SPFileCollection.Add()

How to go about it. Please help me.

Hi,

I wish to add a lookup field to data from a list on another list which is on another site...

Is this possible?

thank you

Kind regards

Chris Sammut

Great help!!!!

You saved a life.....thanks man...thanks a lot

The way to deal with this problem in SP 2003 is to just set the item's ID in the lookup cell.

listItem["FieldName"] = itemID;

'itemID' represents the row number of the item from the external list.

Here is a list of contacts:

ID - Name

1  - Omer

2  - Leshem

3  - Lesh_M

This is an item from another list, the list has LookUp field that's binded to the contacts' names.

listItem["Contact"] = 3; // Lesh_M

Very inspirational...!

Thank you very much for your esteemed work!

Hi Sridhar !

Thanks for the excellent post !!

Can you tell me if there is a way in infopath where we can update(or add a new item) to a custom list which contains 'People or group' type column without using custom C# code. I mean by settings the infopath rules/data connections/sharepoint

I create the class Lookup to validate the fields of Lookup and insert them in SharePoint.

When I create a document, and call this class gives me the following error to save the fields Lookup ...

ERROR:

Value does not fall within the expected range

Class Lookup:

public class WPLookUP : Indice

   {

       DropDownList dropDownList;

       SPFieldLookup lookup;

       public WPLookUP(SPFieldLookup l, string defaultValue)

           : base(l)

       {

           lookup = l;

           dropDownList = new DropDownList();

           bool exist = false;

           SPList list;

           defaultValue = "Escolha uma opção";

           dropDownList.Items.Add(new ListItem(string.Empty, string.Empty));

           using (SPSite site = new SPSite(WebSettings.SiteUrl + WebSettings.DCSite))

           {

               using (SPWeb web = site.OpenWeb())

               {

                   list = web.Lists.GetList(new Guid(lookup.LookupList), false);

                   SPListItemCollection items = list.Items;

                   foreach (SPListItem spitem in items)

                   {

                       ListItem item = new ListItem();

                       string value = (string)spitem[lookup.Title];

                       SPFieldLookupValue lookupValue = (SPFieldLookupValue)lookup.GetFieldValue(value);-> Error

                       item.Text = lookupValue.LookupValue;

                       item.Value = lookupValue.LookupValue;

                       item.Attributes.Add("LookupId", lookupValue.LookupId.ToString());

                       if (defaultValue != null)

                       {

                           if (defaultValue.Equals(spitem[lookup.LookupField].ToString()))

                           {

                               item.Selected = true;

                               exist = true;

                           }

                       }

                       dropDownList.Items.Add(item);

                   }

               }

           }

       }

Help ME

Hi Sridhar,

Many thanks for sharing a useful information about lookup fields.

In my case i am retrieving a lookup field value in my custom search results.

There it is being displayed with its ID

1;#A

2;#B

3;#C

4;#D

5;#E

And i want to display only the values.

Any help how i can override this beahvior(adding ID with value) of lookup field in sharepoint?