Validation Settings for SharePoint list using PowerShell

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#:

1. using System;

2. using System.Collections.Generic;

3. using System.Linq;

4. using System.Text;

5. using Microsoft.SharePoint;

6. namespace ValidationSettings

7. {

8. class Program   

9. {

10. static void Main(string[] args)       

11. {

12. using (SPSite site = new SPSite("http://serverName:1111/"))           

13. {

14. using (SPWeb web = site.RootWeb)               

15. {                 

16. SPList list=web.Lists["cl"];                   

17. list.ValidationFormula = "=AND([Years of Experience]>3,[Years of Experience]<6)";                   

18. list.ValidationMessage = "Years of experience must be between 3-6 years";                   

19. list.Update();               

20. }           

21. }       

22. }   

23. }

24. }
    

Using PowerShell:

1. $site=Get-SPSite "http://serverName:1111/"

2. $web=$site.RootWeb

3. $list=$web.Lists["cl"];

4. $list.ValidationFormula = "=AND([Years of Experience]>3,[Years of Experience]<6)"

5. $list.ValidationMessage = "Years of exxperience must be between 3-6 years"

6. $list.Update()
   

List Validation: