Any help is greatly appreciated. Here is the scenario:
I have a PowerShell script that I use in another message on stackexchange.
I have two fields in one list, the script copies the value of one field into another and works fine, but I would like to add conditional logic in the script.
TestPublishedDate is updated by testupdatedate field however, I would like for TestPublishedDate only to be updated if it is empty.
Here is the script I use:
#Add SharePoint PowerShell Snapin which adds SharePoint specific cmdlets
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
#Variables that we are going to use for list editing
$listName = "Approvals"
#Get the SPWeb object and save it to a variable
$web = Get-SPWeb http://discoverydev09/
#Get the SPList object to retrieve the "Demo List"
$list = $web.Lists($listName)
#Get all items in this list and save them to a variable
$items = $list.items
#Go through all items
foreach($item in $items)
{
$user = $item("testupdatedate")
#Change the value of the "Title" column
$item("TestPublishedDate") = $user
#Update the item
$item.Update()
}
I'm sure it's something simple, the list will have to be displayed daily on a list of more than 5,000 items. If there are any tips to make this script simpler, feel free to let me know!
Or even if PnP could be used to make this easier?
Thank you
