Powershell script to copy value of Created By user field to another field

Question

I created a custom list and here I want to copy Created By column value to another field in same list

• Source Field: Created By
• Destination Field: Item Created User (this is Person/Group Field)

I have SP 2013 & Presently no workflows configured. I want to do by Simple PowerShell script.

Answer 1

I made this PowerShell script for you

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$listName = "CustomList1"

#Get the SPWeb object
$web = Get-SPWeb http://spwapp/

#Get the SPList
$list = $web.Lists[$listName]

#Get all items in this list
$items = $list.items

#Go through all items
foreach($item in $items)
{
    $created = $item["Created By"]
    $item["DestinationPG"] = $created

    #Update the item
    $item.Update()

}

Copy and Paste this script, refer to your SP2013 site url and your List name, and execute it, it will update all the items at once.

FROM THIS

TO THIS

If this answers suit you, please upvote and accept it as an answer