Forum Discussion

JasonC4's avatar
JasonC4
Copper Contributor
Apr 01, 2022
Solved

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 ...
microsoft lists
teams
Usage
  • Micca0815's avatar
    Micca0815
    Apr 01, 2022

    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
Apr 01, 2022

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
Apr 12, 2024

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