Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong?

For Person fields

"@currentField.title"         Works
"@currentField.email"         Works
"[$ThisField.title]"          Works
"[$ThisField.email]"          Works
"[$OtherField.title]"         Doesn't work

For Text fields

"[$OtherField]"               Works for some but not others

For Number fields

"[$OtherField]"               Doesn't work

For Calculated fields

"[$OtherField]"               Doesn't work
"[$OtherField.lookupvalue]"   Doesn't work

Here is my code, which I've labelled on the left with Yes/No on whether the reference to a variable actually works:

  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "children": [
      "elmType": "span",
      "style": {
        "padding-right": "8px"
Y      "txtContent": "[$Owner.title]"
      "elmType": "a",
      "attributes": {
        "iconName": "Mail",
        "class": "sp-field-quickActions",
        "href": {
          "operator": "+",
          "operands": [
Y           "@currentField.email",
            "?subject=Task status&body=You are marked as owner of this task. Reminder prompt activated.\r\n---\r\n",
            "Raised by: ",
N           "[$OtherPersonField.title]",
            "\r\nOwner: ",
Y           "[$ThisPersonField.title]",
            " and Issue Detail %2D ",
Y           "[$ThisPersonField.email]",
            "\r\nPriority: ",
Y           "[$TextFieldA]",
            "\r\nContext: ",
N           "[$ACalculatedField]",
            " at ",
N           "[$TextFieldB]",
            "\r\nIssue: Checklist No. %2D ",
N           "[$NumberField]",
            " and Issue Detail %2D ",
N           "[$LongTextField]",
            "\r\nClick this link for more info. https://PATH.sharepoint.com/sites/SITE/Lists/LIST/VIEW.aspx?web=1%26useFiltersInViewXml=1%26FilterField1=ThisPersonField%26FilterValue1=",
Y           "@currentField.title",

All of the fields that I am trying to reference are shown in the current view.

  • What about fields with more than 1 word? I have played with about every format and none work.
    – Dan Paul
    Mar 3, 2020 at 20:53

1 Answer 1


Go to List Settings > Click on the Column name enter image description here

goto URL there, then get the last name after the last "=" Mark

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.