PowerShell Script to replace values in list not working

Question

I have a script that is supposed to go into a list and find a replace values with a different value in a column. The error I get is 'You cannot call a method on null-valued expression' pointing to this line ($oldurl.URL = $oldurl.URL.Replace("T9", "DR"))

Any idea what's wrong?

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$siteUrl = "https://[siteName]"

$webName = “Resources”

$listName = "Training"

$spSite = new-object Microsoft.SharePoint.SPSite($siteurl)

$spWeb = $spSite.OpenWeb($webName)

$spList = $spWeb.Lists[$listName]

Write-Host("URL: [$spList]")

foreach($Item in $spList.Items )

{

$oldurl = new-object Microsoft.SharePoint.SPFieldUrlValue($Item["INUM"])

$oldurl.URL = $oldurl.URL.Replace("T9", "DR")

Write-Host("URL: [$oldurl]")

$Item.Update()

}

$spWeb.Dispose()

Mohamed El-Qassas MVP · Accepted Answer · 2021-01-12 18:47:50Z

Looks like the $Item["INUM"] doesn't have a value at the first retrived item, so the $oldurl is NULL! and you can't use the replace function with a NULL string

So you should check if the $oldurl is not null before calling the replace function as the following:

foreach($Item in $spList.Items)
{
$oldurl = New-Object Microsoft.SharePoint.Client.FieldUrlValue($Item["INUM"])
if ($oldur -eq $null)
{continue}
else
{
  $oldurl.URL = $oldurl.URL.Replace("T9", "DR")
  Write-Host("URL: [$oldurl]")
  $Item.Update()
}

}

or

foreach($Item in $spList.Items)
{
$oldurl = New-Object Microsoft.SharePoint.Client.FieldUrlValue($Item["INUM"])
if ($oldur -ne $null)

{
  $oldurl.URL = $oldurl.URL.Replace("T9", "DR")
  Write-Host("URL: [$oldurl]")
  $Item.Update()
}
 else continue

}

Amos · Accepted Answer · 2021-01-13 02:55:22Z

0

As Mohamed said, you could add a judgment statement to avoid the null value exception， and you need to re-assign the modified value to item.

foreach($Item in $spList.Items)
{
$oldurl = New-Object Microsoft.SharePoint.SPFieldUrlValue($Item["INUM"])
if ($oldur -ne $null)

{
  $oldurl.URL = $oldurl.URL.Replace("T9", "DR")
  Write-Host("URL: [$oldurl]")
$Item["INUM"]= [Microsoft.SharePoint.SPFieldUrlValue]$oldurl
  $Item.Update()
}
 else continue

}

edited Jan 13, 2021 at 2:55

answered Jan 13, 2021 at 2:39

Amos

2,0261 gold badge8 silver badges12 bronze badges

Add a comment |

Stack Exchange Network

PowerShell Script to replace values in list not working

2 Answers 2

Your Answer

Hot Network Questions

PowerShell Script to replace values in list not working

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions