Column formattingSharePoint Online

Display URLs in Hyperlink Column

This sample demonstrates displaying a URL in a hyperlink column.

Get this format View on GitHub

Shared by Watana, Tetsuya Kawahara
Updated Sep 16, 2024

Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

2 definitions

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Definition

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "style": {
        "display": "=if(@currentField,'flex','none')",
        "flex-direction": "column",
        "margin": "6px"
      },
      "children": [
        {
          "elmType": "img",
          "style": {
            "max-width": "100px",
            "max-height": "100px"
          },
          "attributes": {
            "src": "@currentField",
            "alt": "@currentField.desc"
          }
        },
        {
          "elmType": "a",
          "txtContent": "=if(@currentField.desc,@currentField.desc,'No alternative text')",
          "attributes": {
            "href": "@currentField",
            "target": "_blank",
            "class": "ms-fontSize-s"
          }
        },
        {
          "elmType": "div",
          "txtContent": "@currentField",
          "style": {
            "word-break": "break-all"
          },
          "attributes": {
            "class": "ms-fontSize-xs"
          }
        }
      ]
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "style": {
        "display": "=if(@currentField,'flex','none')",
        "flex-direction": "column",
        "margin": "6px"
      },
      "children": [
        {
          "elmType": "img",
          "style": {
            "max-width": "100px",
            "max-height": "100px"
          },
          "attributes": {
            "src": "@currentField",
            "alt": "@currentField.desc"
          }
        },
        {
          "elmType": "a",
          "txtContent": "=if(@currentField.desc,@currentField.desc,'No alternative text')",
          "attributes": {
            "href": "@currentField",
            "target": "_blank",
            "class": "ms-fontSize-s"
          }
        },
        {
          "elmType": "div",
          "txtContent": "@currentField",
          "style": {
            "word-break": "break-all"
          },
          "attributes": {
            "class": "ms-fontSize-xs"
          }
        }
      ]
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "style": {
        "display": "=if(@currentField,'flex','none')",
        "flex-direction": "column",
        "margin": "6px"
      },
      "children": [
        {
          "elmType": "a",
          "txtContent": "=if(@currentField.desc,@currentField.desc,'No alternative text')",
          "attributes": {
            "href": "@currentField",
            "target": "_blank",
            "class": "ms-fontSize-s"
          }
        },
        {
          "elmType": "div",
          "txtContent": "@currentField",
          "style": {
            "word-break": "break-all"
          },
          "attributes": {
            "class": "ms-fontSize-xs"
          }
        }
      ]
    }
  ]
}

.definition[hidden] { display:block !important; } .variant-chooser,[data-copy] { display:none; }All definitions are shown below. Select the code manually or download the JSON file.

From the contributor

How to use this sample

Summary

This sample demonstrates displaying a URL in a hyperlink column. By showing the URL, users can preview the linked site or page before clicking on the link. Additionally, making the URL visible allows users to quickly identify the link’s destination during maintenance, making it easier to modify or update.

screenshot of the sample

View requirements

This format can be applied to a Hyperlink column.

Sample

Solution	Author(s)
hyperlink-display-url.json	Watana & Tetsuya Kawahara
hyperlink-display-url-format-picture.json	Watana & Tetsuya Kawahara

Version history

Version	Date	Comments
1.0	September 16, 2024	Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.