Set Calculated Field Formula in SharePoint using CSOM

The example in this topic show how to use CSOM to Set Calculated Field Formula in SharePoint

  • 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("Calculated Field Name");
  •  
  • // Cast field to "Calculated Field"
  • FieldCalculated calculatedfield = clientcontext.CastTo<FieldCalculated>(oField);
  •  
  • // Set calculated field formula
  • calculatedfield.Formula = "=LOWER([Office Location])";
  •  
  • oField.Update();
  • clientcontext.ExecuteQuery();
  • }

Thank you for reading this article. This code was tested in SharePoint 2013


© 2019 Code SharePoint