Forum Discussion

JasonC4's avatar
JasonC4
Copper Contributor
Apr 01, 2022

List - Conditional formatting for blank text field

I'm using Lists via Teams (Office 365). I've got a list with a "single line text" column. I'd like to add some conditional formatting if the column contents are not blank.

 

The only options I see in the conditional formatting dialog are "is equal to" and "is not equal to", so I picked "is not equal to", but it won't accept an empty value in the "choose a type or value" box (which is a plain text field, it's not a dropdown). I tried empty single quotes and empty double quotes but that didn't work.

 

 

How do I do this?

 

Thanks!!

  • JasonC4 

    You might want to open the 'Advanced mode' linked at the very bottom above the save button.
    In here the operand accepts double quotes for 'blank fields' (line 18).

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "div",
      "style": {
        "box-sizing": "border-box",
        "padding": "0 2px",
        "overflow": "hidden",
        "text-overflow": "ellipsis"
      },
      "attributes": {
        "class": {
          "operator": ":",
          "operands": [
            {
              "operator": "==",
              "operands": [
                "[$SingleLineOfText]",
                ""
              ]
            },
            "sp-css-backgroundColor-BgGold",
            ""
          ]
        }
      },
      "txtContent": "[$SingleLineOfText]"
    }

     

  • Micca0815's avatar
    Micca0815
    Iron Contributor

    JasonC4 

    You might want to open the 'Advanced mode' linked at the very bottom above the save button.
    In here the operand accepts double quotes for 'blank fields' (line 18).

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "div",
      "style": {
        "box-sizing": "border-box",
        "padding": "0 2px",
        "overflow": "hidden",
        "text-overflow": "ellipsis"
      },
      "attributes": {
        "class": {
          "operator": ":",
          "operands": [
            {
              "operator": "==",
              "operands": [
                "[$SingleLineOfText]",
                ""
              ]
            },
            "sp-css-backgroundColor-BgGold",
            ""
          ]
        }
      },
      "txtContent": "[$SingleLineOfText]"
    }

     

    • Shaune1215's avatar
      Shaune1215
      Copper Contributor

      Micca0815 This works great on a list view; however, It does not work for any of the form views.  I've tried multiple methods to try to highlight a blank field (number or text) on a form field but nothing has worked so far.  Do you know why this is?

       

      List View with formatting looks great.

      Form View formatting is not present.  Instead SP displays an em dash?

       

      If I change the formula to look for any value, for example "test123", the formatting does show up on the form view.  The only thing that does not work is blank fields on the form view.  Any advice?

Resources