Forum Discussion

JerryZ1977's avatar
JerryZ1977
Copper Contributor
Jan 26, 2024

Need help in setting up Indicators from a SharePoint List to a SharePoint Page

I have a SharePoint list set up that currently has indicators of the status of deployment for systems (Deployed, In Development, Will not be Deployed, etc...) and a previous colleague had set this up...
SharePoint Online
Rob_Elliott's avatar
Rob_Elliott
Silver Contributor
Jan 27, 2024

JerryZ1977  further to ganeshsanap 's post, a simple bit of JSON column formatting is shown below and you would format each column with it. You then add a list web part to your page:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "padding-left": "8px",
    "color": "white",
    "background-color": "=if(@currentField == 'Not Started', '#ff0000', if(@currentField == 'Deployed', '#008080', if(@currentField == 'In Development', '#ff7400', if(@currentField == 'Will Not Be Deployed', '#8d8f90', ''))))"
  }
}

 

 


Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources