Use Below Code to Update a Site Column for a Document Library
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$web=get-SPWeb "http://myweb/sites/demant"
$web.title
$list=$web.Lists["Demant"]
$list.title
foreach($item in $list.Items)
{
if($item["Column A"] -ne "Yes")
{
$item["Column B"] = "Good"
$item.update()
}
else {If($item["Column A"] -eq "Yes")
{
$item["Column B"] = "NotGood"
$item.update()
}
}
}
$web.dispose()
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Get the Site Collection
$site = Get-SPsite "http://mywebapp"
foreach($web in $site.AllWebs)
{
foreach($list in $web.Lists)
{
if(($List.BaseType -eq "DocumentLibrary") -and ($List.Hidden -eq $false) -and ($List.IsApplicationList -eq $false))
{
foreach ($item in $list.Items)
{
if($item["Column A"] -ne "Yes")
{
$item["Column B"] = "Restricted"
$item.update()
}
else {If($item["Column A"] -eq "Yes")
{
$item["Column B"] = "Confidential"
$item.update()
}
}
}
}
}
}
$web.dispose()
Use Below Code to Update/Edit a site column for Entire Site Collection
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Get the Site Collection
$site = Get-SPsite "http://mywebapp"
foreach($web in $site.AllWebs)
{
foreach($list in $web.Lists)
{
if(($List.BaseType -eq "DocumentLibrary") -and ($List.Hidden -eq $false) -and ($List.IsApplicationList -eq $false))
{
foreach ($item in $list.Items)
{
if($item["Column A"] -ne "Yes")
{
$item["Column B"] = "Restricted"
$item.update()
}
else {If($item["Column A"] -eq "Yes")
{
$item["Column B"] = "Confidential"
$item.update()
}
}
}
}
}
}
$web.dispose()
No comments:
Post a Comment