Error in JSON formating

Question

Hi.

I want to use formatting in Sharepoint via JSON:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "debugMode": true,
  "txtContent": "@currentField",
  "style": {
    "color": "=if(@currentField<=@now, '#ff0000', ' ')"
  }
}

The result is:

Failure: The value of style =if(@currentField<=@now, '#ff0000', ' ') contains at least one of these illegal characters: ( : & ; ! .

Something is wrong when I can't insert ( in JSON

Thanks

Answer 1

Hi Ladislav Zelinka •

Thanks for the post.

According to the tests, it works as expectation using your json code.

The testing column is 'Date' column.

The following is my testing result: The testing date is 1/16/2023

Please confirm that your input method is in English.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks for testing. I found myself having to use this format for if

{"operator": "?", "operands": [{"operator": "==","operands": ["@currentField", ""]},"Yes","No"]}

Thanks