Set Default Value for Hyperlink or Picture Column in SharePoint

Requirement: Set Default value for Hyperlink or Picture Column in SharePoint List

There is no provision for specifying default value in Hyperlink or Picture type columns in SharePoint! In some scenarios, we may want to specify SharePoint 2010/2013 hyperlink column default value. But there is no option in SharePoint web UI to enter hyperlink field default value!

set sharepoint hyperlink field default value

We can set the SharePoint hyperlink column default value with PowerShell! Use this PowerShell script to specify the default value for hyperlink or picture type fields.

Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue

#Variables
$WebURL="http://intranet.crescent.com"
$ListName="Proposal Documents"
$ColumnName="Reference URL"
$DefaultValue="http://externalsites.crescent.com" 

#Get the Web
$web = Get-SPWeb $WebURL
 
#Get the List
$list = $web.Lists.TryGetList($ListName)
 
If($list -ne $null)
{
 #Get the column
 $column = $list.Fields[$ColumnName]

 if($column -ne $null)
 {
     #Set Default Value
     $column.DefaultValue = $DefaultValue
     $column.Update()
     $list.Update()
     Write-Host " Default value set for the column!" 
 }
 }
$web.Dispose() 

Here is the output for SharePoint 2013 list hyperlink default value specified programmatically:
 sharepoint 2013 hyperlink column default value

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

6 thoughts on “Set Default Value for Hyperlink or Picture Column in SharePoint

  • August 3, 2020 at 12:59 PM

    How do I update, the description

    Reply
  • May 4, 2020 at 3:55 PM

    How to set format url is Picture instead of Hyperlink using server side powershell?

    Reply
  • September 6, 2019 at 7:20 PM

    Hi Rajack,
    Where do you incorporate the PowerShell Script?

    Thanks,
    Linh

    Reply
    • September 19, 2019 at 8:54 PM

      Run the script in PowerShell ISE from any of your SharePoint On-Premises WFE!

      Reply

Leave a Reply