Apply Default Column value using PowerShell? (SP Online)

Question

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.

Nanddeep Nachan · Answer

Try this on opening PowerShell Add-PSSnapin Microsoft.Sharepoint.Powershell

Mark Dave · Answer

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 Nachan · Answer

$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 Kap · Answer

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.