I have a larger list (~6000 items) that I want to copy values from one field to another. Is there an easy way to do this? I'm guessing there is a REST or PowerShell way, but only have limited experience with either.

2 Answers 2


Use Datasheet-View and make Copy+Paste

or this Powershell script:

Add-PSSnapin Microsoft.Sharepoint.Powershell

$site = new-object Microsoft.SharePoint.SPSite("SiteURL”)

$web =  Get-SPWeb -Identity siteURL

$lista =$web.Lists["ListName"]

$items = $lista.items

foreach ($item in $items) {
  $user = $item["Source column"]

  write-host $useracc 

$useracc =  $web.EnsureUser( $user); 

$item["Desination column"] = $useracc

write-host $useracc





This script looks like a direct copy from this page Powershell script to copy a value from one field to another

As noted on that page this script will fail unless the value in the source column are actual user accounts. The poster here has not mentioned user accounts so this line: $useracc = $web.EnsureUser( $user); Needs to be removed

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.