Categories

x

Categories

Recent Articles

Microsoft Flow-Usage and Administration guide for beginners

10 differences between SharePoint List and Library

What is Microsoft Power Apps?

What is Microsoft flow OR Power Automate?

Stay Updated!!

Email Address

Enforce List Column Unique Value in SharePoint using CSOM

The example in this topic show how to use CSOM to Enforce List Column Unique Value 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.

create console application using Visual Studio

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
// NOTE: This column must be indexed in order to Enforce Unique values
Field oField = targetList.Fields.GetByInternalNameOrTitle("Column Name");
oField.EnforceUniqueValues = true;
oField.Update();
clientcontext.ExecuteQuery();
}

Similar examples using different APIs:

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

We value your Feedback:

Page URL:

Name:

Email:

Suggestion: