Enforce List Column Unique Value in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Enforce List Column Unique Value in SharePoint

  • # Provide credentials over here
  • $creds = (New-Object System.Management.Automation.PSCredential "<<UserName>>",(ConvertTo-SecureString "<<Password>>" -AsPlainText -Force))
  •  
  • # Provide URL of the Site over here
  • # If you do not wish to pass credentials hard coded then you can use: -Credentials (Get-Credential). This will prompt to enter credentials
  • Connect-PnPOnline -Url http://MyServer/sites/MySiteCollection -Credentials $creds
  •  
  • # Get Context
  • $clientContext = Get-PnPContext
  •  
  • # -List: The list object or name of the list
  • # -Identity: The field object or name
  • # NOTE: This column must be indexed in order to Enforce Unique values
  • $targetField = Get-PnPField -List "New list" -Identity "My Column"
  •  
  • $targetField.EnforceUniqueValues = 1
  •  
  • $targetField.Update()
  •  
  • $clientContext.ExecuteQuery()
  •  
  • Disconnect-PnPOnline 

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


© 2019 Code SharePoint