SharePoint Online JSON Hyperlink Column Formatting - If empty

I am trying to make a hyperlink column to appear "NA" if empty but if a hyperlink is inputted to show as a clickable "View MSA". I am able to achieve the latter as a clickable link but can't seem to...

SharePoint Online

RobElliott

Sep 14, 2022

Harry_Kane

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "attributes": {
    "href": "@currentField",
    "target": "_blank"
  },
  "txtContent": "=if(@currentField == '', 'NA','View MSA')"
}

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott

Silver Contributor

Sep 14, 2022

Harry_Kane

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "attributes": {
    "href": "@currentField",
    "target": "_blank"
  },
  "txtContent": "=if(@currentField == '', 'NA','View MSA')"
}

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Harry_Kane

Copper Contributor

Sep 14, 2022

Thank you. I see where I went wrong.

Forum Discussion

SharePoint Online JSON Hyperlink Column Formatting - If empty

Resources