powershell script for fixing default URL to SharePoint list column

Question

I am trying to fix default URL for Hyperlink column in share point list and getting an error. Please help to find the problem.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Variables $SiteURL = "http://sharepoint-test/sites/name/" $ListName = "Test list" $FieldName= "default" #Get the Web, List Objects $web = Get-SPWeb $SiteURL $List = $Web.Lists.TryGetList($ListName) If($list) { #sharepoint powershell update hyperlink field $Hyperlink = New-Object Microsoft.SharePoint.SPFieldURLValue $Hyperlink.Description = "Profile Picture" $Hyperlink.URL = "http://sharepoint-test/image/profile.jpg" #Add new List Item $Item = $List.AddItem() $Item[$FieldName] = $default $Item.Update(); Write-host "New Item Added Successfully!" } 

Code returns following error:

Exception calling "Update" with "0" argument(s): "Invalid number value. A number field contains invalid data. Please check the value and try again."

At C:\Users\testuser\Code\test.ps1:22 char:5 + $Item.Update(); + ~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : SPException

Answer 1

You tag says "sharepoint-online". The cmdlets in your samples are for SharePoint on-prem and are typically run on the SharePoint server.

Take a look at the PNP cmdlet library for maintaining sites (webs) and lists in both SharePoint Online and on-prem.

https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-pnp/sharepoint-pnp-cmdlets?view=sharepoint-ps

For tenant admin and creating Site Collections use the SPO cmdlets:

https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-online/introduction-sharepoint-online-management-shell?view=sharepoint-ps

Here's an example using PNP to add an item:

Connect-PnPOnline https://yourDomain/sites/yourSite Add-PnPListItem -List "Announcements" -Values @{"Title" = "Test Title"; "Body"="hello world"} 

Answer 2

We can use the PowerShell below to achieve it.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Variables $SiteURL = "http://sharepoint-test/sites/name/" $ListName = "Test list" $FieldName= "default" #Get the Web, List Objects $web = Get-SPWeb $SiteURL $List = $Web.Lists.TryGetList($ListName) If($list) { #sharepoint powershell update hyperlink field $Hyperlink = New-Object Microsoft.SharePoint.SPFieldURLValue $Hyperlink.Description = "Profile Picture" $Hyperlink.URL = "http://sharepoint-test/image/profile.jpg" #Add new List Item $Item = $List.AddItem() $Item["Title"]="new item" $Item[$FieldName] = $Hyperlink.ToString() $Item.Update() Write-host "New Item Added Successfully!" }