The example in this topic show how to use CSOM to Update List Column Choices in SharePoint
- Please follow the steps below to execute the code in Visual Studio using
Console Application. You can customize the solution according to your requirements.
- Check the article to
Connect to SharePoint context using CSOM. This is very helpful
if you are doing any programming in CSOM.
- Don't forget to use the assemblies as mentioned in the code.
How to run CSOM code in SharePoint?
- Open your Visual Studio.
- From the template, select Console Application as shown in the screenshot
- Select the .Net Framework version from the top drop-down as well.
You can also change the .Net Framework after creating the solution.
- Enter Project Name, Location and Solution
Name and click on OK.
- Now your program.cs file will open. Copy the code in main function.
- Once you are done with your code, just hit F5 or Run the application.
- using Microsoft.SharePoint.Client;
- using System.Linq;
-
- using (ClientContext
clientContext = new ClientContext("http://MyServer/sites/MySiteCollection"))
- {
-
// clientcontext.Web.Lists.GetById - This option also can be used to get the list
using List GUID
-
// This value is NOT List internal name
-
List targetList = clientcontext.Web.Lists.GetByTitle("List Name");
-
-
// Get field from list using internal name or display name
-
Field oField = targetList.Fields.GetByInternalNameOrTitle("Choice Field Name");
-
-
// Cast field to "FieldChoice"
-
FieldChoice oFieldChoice
= clientcontext.CastTo<FieldChoice>(oField);
-
-
// Enter all the choices with separator ';'
-
string choices = "Choice 1;Choice 2;Choice 3";
-
- oFieldChoice.Choices
= choices.Split(";".ToCharArray());
- oFieldChoice.Update();
-
- clientcontext.ExecuteQuery();
-
}
Thank you for reading this article. This code was tested in SharePoint 2013