Get/Set Hyperlink Field Values in SharePoint using PowerShell
Requirement: PowerShell to get and update hyperlink URL field value in SharePoint
Here are my PowerShell scripts to get and set hyperlink column values:
Get Hyperlink Field Value using PowerShell
Here is how to get the URL value of the SharePoint hyperlink field using PowerShell:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Configuration Variables
$SiteURL = "https://intranet.crescent.com/"
$ListName = "UserProfiles"
$FieldName="Picture"
#Get the Web, List Objects
$web = Get-SPWeb $SiteURL
$List = $Web.Lists.TryGetList($ListName)
If($list)
{
foreach($Item in $List.Items)
{
#Get the Hyperlink column
$Picture = New-Object Microsoft.SharePoint.SPFieldUrlValue($Item[$FieldName])
#Get the URL of the Hyperlink
$Picture.URL
#Get the Decription - Title
$Picture.Description
}
}
Update Hyperlink Field value using PowerShell:
Here is the SharePoint PowerShell to set the hyperlink field.
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Configuration Variables
$SiteURL = "https://intranet.crescent.com/"
$ListName = "UserProfiles"
$FieldName="Picture"
#Get the Web, List Objects
$web = Get-SPWeb $SiteURL
$List = $Web.Lists.TryGetList($ListName)
If($list)
{
#sharepoint powershell update hyperlink field
$Picture = New-Object Microsoft.SharePoint.SPFieldURLValue
$Picture.Description = "Profile Picture"
$Picture.URL = "https://intranet.crescent.com/UserProfiles/Images/profile.jpg"
#Add new List Item
$Item = $List.AddItem()
$Item[$FieldName] = $Picture
$Item.Update()
Write-host "New Item Added Successfully!"
}
Thanks for sharing the link to your blog.
Cheers,
Uttkarsh
Hi,
This is script is great and works perfectly in the PowerShell. Could you please help me with how to export this Get list data to export in a CSV please?
Many Thanks,
Uttkarsh
Here you go: How to Export SharePoint List Items to CSV using PowerShell