The example in this topic show how to use CSOM to Check List Column Existence 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");
-
-
FieldCollection fieldCollection
= targetList.Fields;
-
-
// Load field from list using internal name or display name
- clientcontext.Load(fieldCollection,
fields => fields.Include(fieldObject => fieldObject.Title).Where(fieldObject
=> (fieldObject.Title == "Column Name")
|| (fieldObject.InternalName == "Column Internal Name")));
-
- clientcontext.ExecuteQuery();
-
-
if (fieldCollection.Count
!= 0)
- {
- Console.WriteLine("Column exists");
- }
-
else
- {
- Console.WriteLine("Column does not
exist");
- }
- }
Thank you for reading this article. This code was tested in SharePoint 2013