Forum Discussion

newbeetle's avatar
newbeetle
Copper Contributor
Oct 20, 2021
Solved

JSON If Statement

Hi I have an If Statement that conditionally formats the background based on a date as follows;   "attributes": { "class": "=if(@currentField <= @now,'sp-field-severity--blocked', if(@currentFiel...
JSON If Statement
  • RobElliott's avatar
    RobElliott
    Oct 21, 2021

    newbeetle the simpler JSON is:

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if([$Status] == 'Failed', '#7d0000', ((if(@currentField <= @now, 'red', if((@currentField >= @now && @currentField <= @now + 7776000000),'orange','green')))",
    "color": "white"
  }
}

     

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

ChrisHois's avatar
ChrisHois
Copper Contributor
Nov 25, 2024

SHAREPOINT 2016 on premise engine  DOES NOT support IF statements !!? :-(   bad SP ENgine.
always SP online is the focus. Other version are only partially supported with full commands .

whats a pitty :-)    ☹️

 

{

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

  "elmType": "div",

  "txtContent": "=if(@currentField == 'http://example.com', 'Ja', 'Nein')"

}

This doesnt work. IF Statement never works. Code comes back to the SP column in the GUI.

Resources