Powershell Script to Copy the value of one column to another column in the same SharePoint List.
$site = new-object Microsoft.SharePoint.SPSite("http://localhost")
$web = Get-SPWeb -Identity http://localhost
$list =$web.Lists["List/Library Name"]
$items = $list.items
foreach ($item in $items)
{
$sourcevalue = $item["Column 1"]
$item["Column 2"] = $sourcevalue
write-host $sourcevalue
$item.update()
}
$list.update()
$site = new-object Microsoft.SharePoint.SPSite("http://localhost")
$web = Get-SPWeb -Identity http://localhost
$list =$web.Lists["List/Library Name"]
$items = $list.items
foreach ($item in $items)
{
$sourcevalue = $item["Column 1"]
$item["Column 2"] = $sourcevalue
write-host $sourcevalue
$item.update()
}
$list.update()
I used the above code and it changed the Modified by user to system account. Not sure how to revert it back. Can you please help?
ReplyDelete