Forum Discussion

annetoal's avatar
annetoal
Brass Contributor
Jun 03, 2022
Solved

JSON formatting of SharePoint list

I am using some JSON code from Reza Dorrani's GitHub to make an approval timeline in a SharePoint list. The code allows you to have 4 different statuses: Status                Color              Pos...
tutorial JSON SharePoint
  • PamDeGraffenreid's avatar
    PamDeGraffenreid
    Jun 03, 2022

    annetoal slip this into line 53 -- if([$Status]=='Deleted','ms-bgColor-black'

    "class": "=if([$Status]=='Rejected','ms-bgColor-red',if([$Status]=='Deleted','ms-bgColor-black',if([$Status]=='Pending','ms-bgColor-yellow',if([$Status]=='Approved','ms-bgColor-green','ms-bgColor-blue')))"

     

PamDeGraffenreid's avatar
PamDeGraffenreid
MVP
Jun 03, 2022

annetoal slip this into line 53 -- if([$Status]=='Deleted','ms-bgColor-black'

"class": "=if([$Status]=='Rejected','ms-bgColor-red',if([$Status]=='Deleted','ms-bgColor-black',if([$Status]=='Pending','ms-bgColor-yellow',if([$Status]=='Approved','ms-bgColor-green','ms-bgColor-blue')))"

 

annetoal's avatar
annetoal
Brass Contributor
Jun 03, 2022
Thank you very much. It worked a treat.

Anne

Resources