Using JSON to hide or show row depending on a row value

Question

Can anyone explain this? I wrote this JSON back in June. It's to show birthdays for the current month. I have a simple list with a date field. To hide rows that are not in current month, I am comparing getMonth of the birth date versus @now.

Notice: my txtContent shows the result of the evaluation. When I publish the view - I'm getting no data. (Oddly - this worked in June and July.)

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "hideSelection": true,
  "hideColumnHeader": true,
  "rowFormatter": {
    "elmType": "div",
    "style": {
      "display": "=if(getMonth([$DateOfBirth])==getMonth(@now)), 'block', 'none')",      
      "white-space": "nowrap",
      "overflow": "hidden",
      "margin": "1px 4px 4px 1px"
    },
    "attributes": {
      "max-width": "150px"
    },
    "children": [
      {
        "elmType": "div",
        "style": {
          "text-align": "left",
          "font-size": "18px",
          "font-weight": 400,
          "font-family": "Segoe UI, Arial, Tahoma"
        },
        "children": [
          {
            "elmType": "span",
            "_comment_": "=getMonth([$DateOfBirth])+'/'+getDate([$DateOfBirth])+' - '+[$Title]+' - '+getMonth(@now)",
            "txtContent": "=getMonth([$DateOfBirth])==getMonth(@now)"
          }
        ]
      }
    ]
  }
}

When I preview - I get only TRUE entries (those with matching month values). When I save and refresh - it shows blank.

Answer 1

There is a syntax error in your below expression:

"display": "=if(getMonth([$DateOfBirth])==getMonth(@now)), 'block', 'none')",

You have one additional ) after getMonth(@now).

Try using below JSON code, it should work for you:

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
    "hideSelection": true,
    "hideColumnHeader": true,
    "rowFormatter": {
        "elmType": "div",
        "style": {
            "display": "=if(getMonth([$DateOfBirth])==getMonth(@now), 'block', 'none')",
            "white-space": "nowrap",
            "overflow": "hidden",
            "margin": "1px 4px 4px 1px"
        },
        "attributes": {
            "max-width": "150px"
        },
        "children": [
            {
                "elmType": "div",
                "style": {
                    "text-align": "left",
                    "font-size": "18px",
                    "font-weight": 400,
                    "font-family": "Segoe UI, Arial, Tahoma"
                },
                "children": [
                    {
                        "elmType": "span",
                        "_comment_": "=getMonth([$DateOfBirth])+'/'+getDate([$DateOfBirth])+' - '+[$Title]+' - '+getMonth(@now)",
                        "txtContent": "=getMonth([$DateOfBirth])==getMonth(@now)"
                    }
                ]
            }
        ]
    }
}

Answer 2

So - it seems the issue was a glitch in the platform. The following day, when I previewed All Items, the entries that I submitted the day before still had the "new" moniker on them. I edited an existing entry from March to August, and suddenly the view started working. I changed the entry back to March - and the view continued to work as expected. My take on this - SharePoint wasn't refreshing properly. Makes no sense, and really supports my feeling of the 80/20 rule with this environment being wonky, ill-behaved, and occasionally unreliable.

With that said: job security. :-)