In this article we will be seeing about the validation settings for SharePoint list using PowerShell. Go to List => List Settings => General Settings => Validation Settings. We can add the formula to validate and give some error message. I have a column "Years of experience" and I am going to add the validation formula as shown in the following Using C#: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint;
namespace ValidationSettings { class Program { static void Main(string[] args) { using (SPSite site = new SPSite("http://serverName:1111/")) { using (SPWeb web = site.RootWeb) { SPList list=web.Lists["cl"]; list.ValidationFormula = "=AND([Years of Experience]>3,[Years of Experience]<6)"; list.ValidationMessage = "Years of exxperience must be between 3-6 years"; list.Update(); } } } } } Using PowerShell: $site=Get-SPSite "http://serverName:1111/" $web=$site.RootWeb $list=$web.Lists["cl"]; $list.ValidationFormula = "=AND([Years of Experience]>3,[Years of Experience]<6)" $list.ValidationMessage = "Years of exxperience must be between 3-6 years" $list.Update() List Validation:
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: