Forum Discussion

Harry_Kane's avatar
Harry_Kane
Copper Contributor
Sep 14, 2022
Solved

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's avatar
    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)

batvan276's avatar
batvan276
Copper Contributor
Sep 14, 2022

ganeshsanap this is great . You got the format I wanted.

 

Thank you.

ganeshsanap's avatar
ganeshsanap
MVP
Sep 15, 2022

batvan276 You are welcome, glad it helped you and you got the results you were looking for!

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources