Hi,

How to update a choice field?

I have a choice field(dropdown) in my custom list, which has the value as "Start", "In Progress", "End".

I would like to update the list items which have the value as "In Progress" to "End" programmatically.

Is the below code correct. I have not got any errors, however would like to know if the below is proper. I have not provided the condition in the below code, however the update code i have added

myListItem["ChoiceField"] = myList.Fields["ChoiceField"].GetFieldValue("End");
myListItem.Update();
myList.Update();

Thank you

• Edited by Venkatzeus Monday, October 29, 2012 1:56 PM added more info

did you miss to update the field?

myListItem["ChoiceField"].Update();

HI,

Thank you very much for the reply. But is this not fine:

myListItem.Update();

Also, is the first line correct?

Thanks

• Edited by Venkatzeus Monday, October 29, 2012 2:11 PM

Hello,

actually with choice field it is enough to state text value you wish to set (unlike lookup field)

This works for me

SPListItem item = ...
item["ChoiceField"] = "End";
item.Update();

Hope this helps,

Hi Venkat,

 Please try to look at the below example code snippet. It may help you to accomplish your task,

• Proposed as answer by SekThangMicrosoft community contributor Monday, October 29, 2012 5:06 PM
• Unproposed as answer by Venkatzeus Tuesday, October 30, 2012 5:55 AM
• Proposed as answer by SekThangMicrosoft community contributor Tuesday, October 30, 2012 7:08 AM
• Unproposed as answer by Venkatzeus Tuesday, October 30, 2012 9:44 AM
• Proposed as answer by navathehutt Monday, July 14, 2014 12:34 AM

Hi,

@SekThang - I am unproposing the answer, as i am not adding new records to the choice field.

I am trying to update the choice field.

Hi,

 Venkat- Why don't you do like  just set it as a string. That's how the values of choice fields are stored internally.

 Just look at the below sample code snippet.

• Proposed as answer by SekThangMicrosoft community contributor Tuesday, October 30, 2012 11:13 AM
• Marked as answer by Venkatzeus Tuesday, October 30, 2012 11:44 AM

                   object folderTitle;
                    if (properties.TryGetValue("Title", out folderTitle))
                        newItem["Title"] = folderTitle;
                    foreach (var kvp in newItemProperties)
                    {
                        newItem[kvp.Key] = kvp.Value;
                    }
		    newItem.Update();
                    clientContext.Load(newItem);
                    clientContext.ExecuteQuery();

I have list of the properties on the newItemproperties and then i run the following code it gives me error as :Item does not exist. It may have been deleted by another user.

I have inner exception as: 

 at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)
   at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()
   at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryToServer(ChunkStringBuilder sb)
   at Microsoft.SharePoint.Client.ClientRequest.ExecuteQuery()
   at Microsoft.SharePoint.Client.ClientRuntimeContext.ExecuteQuery()
   at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery()

Why is am i getting this error??
Is there anything i have missed to do??

Hello,

actually with choice field it is enough to state text value you wish to set (unlike lookup field)

This works for me

SPListItem item = ...
item["ChoiceField"] = "End";
item.Update();

Hope this helps,