Apply Default Column value using PowerShell? (SP Online)

Mark Dave

I have a SharePoint site collection in Office 365 SharePoint Online - subsites underneath and each subsite has a Document Library. Each library has set of folders and subfolders.

I would like to apply Column Default value settings using PowerShell. Currently, I am applying these values manually. (i.e. Library Settings - Column Default value settings - click on each folder name and apply value for each Column into "Default Value" text box)

Thank you.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Try this on opening PowerShell
Add-PSSnapin Microsoft.Sharepoint.Powershell
Mark Dave8y ago
Thank you both.

I am getting this error - I am using SharePoint online.

"The term 'Get-SPWeb' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

At line:1 char:99"

This is my script:
Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue
Get-SPOSite "https://site.aspx" | Get-SPWeb -Limit All | %{
$list = $_.Lists["Documents"]
if($list -ne $null)
{
Write-Host "Found List on $_."
$field = $list.Fields["Name"]
$field.DefaultValue = "Value"
$field.Update()
}
}
Nanddeep Nachan8y ago
$aClient = [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client")
$aClientRuntime = [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.Runtime")
$Credentials = Get-Credential -Message "Enter your credentials"
$Url = "https://yourtenant.sharepoint.com"
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($Url)
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Credentials.UserName,$Credentials.Password)
$clientweb = $ctx.Web
$ctx.Load($clientweb)
$docLib = $clientweb.Lists.GetByTitle('Documents')
$field = $docLib.Fields.GetByTitle("MyManagedMetadataField")
$field.DefaultValue = "22;#Academics|bc943091-79ac-4f5f-a79b-205e8e717823"
$field.Update()
$ctx.Load(field)
$ctx.ExecuteQuery()
Sagar Pandurang Kap8y ago
Hi,
Try :-

https://social.technet.microsoft.com/Forums/en-US/fec63d5f-1e63-40cc-b721-631babf11e19/apply-column-default-value-settings-using-powershell?forum=SP2016
https://social.technet.microsoft.com/Forums/en-US/fec63d5f-1e63-40cc-b721-631babf11e19/apply-column-default-value-settings-using-powershell?forum=SP2016

Hope it helps.