JSON - Conditional Formatting - SharePoint - Not Null

Question

New to JSON. Trying to write JSON when ever a free form text field is filled out, have this but don't know how to get it to highlight when anything is entered. I do not want highlights on blank items:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField == '','sp-field-severity--good','')"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

Can you please explain what are the conditions to highlight the cell? — Ganesh Sanap - MVP
– Ganesh Sanap - MVP, Commented Aug 27, 2020 at 2:04

Michael Han · Accepted Answer · 2020-08-27 06:25:34Z

1

Just change your code to this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField == '','','sp-field-severity--good')"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

answered Aug 27, 2020 at 6:25

Michael Han

5,2411 gold badge9 silver badges12 bronze badges

Add a comment |

Ganesh Sanap - MVP · Accepted Answer · 2020-10-05 16:32:21Z

You need to add a style parameter to apply styling and this can be conditional, as you see below. In style or class I have made certain changes which should work for you

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField,'sp-field-severity--good','')"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px",
        "color": "=if([@currentField] == '', 'red', 'black')"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

Stack Exchange Network

JSON - Conditional Formatting - SharePoint - Not Null

2 Answers 2

Your Answer

Hot Network Questions

JSON - Conditional Formatting - SharePoint - Not Null

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions