Thursday, September 26, 2013

How To Update a List Column using Powershell

Use Below Code to Update a Site Column for a Document Library

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()


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