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

Mark Gorelyk 61 Reputation points

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?


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,807 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,461 Reputation points

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


    You could also meet your requirement using pnp:

    $SiteURL = ""  
    $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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful