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.

Apply Default Column value using PowerShell? (SP Online)

Answers (4)