Default Value for Sharepoint List Column Value (NOT document library) - PNP PowerShell

Question

Dear all,

could you advice how to set a default column value for a SharePoint list? I am aware of Set-PnPDefaultColumnValues for document libraries, but what would work with a list?
My use case: List with quite a lot of columns which all need the same value as the default. Any way round doing this manually?

Regards

Answer 1

Hi @Mark Gorelyk
You could set default value for column here:

You could also meet your requirement using pnp:

$SiteURL = "https://Crescent.sharepoint.com"  
$ListName = "Team Documents"  
$ColumnName = "color"   
$DefaultValue = "1"  
   
#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  
   
#Set Default Value for the field  
Set-PnPField -Identity $ColumnName -List $ListName -Values @{DefaultValue=$DefaultValue}  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.