SharePoint column formatting generator
Column formatting lets a SharePoint list highlight the items that matter, like an Urgent priority in red, without changing any data. The JSON is fiddly to write from scratch. Set the column, the condition and the colour, and copy JSON you can paste straight into the column's formatting panel.
SharePoint column formatting
CONDITIONAL BACKGROUND Colour
PASTE STRAIGHT INTO COLUMN FORMATTING
Paste this into a SharePoint list column's "Format this column" → Advanced mode.
How to use it
- Enter the column's internal name. It can differ from the display name; you'll find it at the end of the URL when you open the column's settings.
- Choose the condition, the value to match and a background colour.
- In the list, open the column's menu, choose Column settings, then Format this column, switch to Advanced mode and paste the JSON.
Nothing you type here is sent anywhere. The tool runs entirely in your browser.
More free tools
EVERY TOOL RUNS IN YOUR BROWSER
NO SIGN-IN, NOTHING STORED
Power Automate expression builder
Pick a function, fill in the values, copy a working expression.
Trigger condition and filter builder
Conditions in, a trigger condition or Power Fx Filter formula out.
formatDateTime generator
Pick a date source and a format, get the formatDateTime expression.
SVG to Power Apps image converter
Paste SVG markup, get a data URI for the Image property.
Parse JSON schema generator
Paste a sample payload, get the schema for a Parse JSON action.
Parse JSON schema loosener
Fix Parse JSON failing on null values or missing fields.
Adaptive Card builder
Title, body and Approve / Reject buttons, as card JSON for Teams.
Flow error handler (Try / Catch)
Run-after settings, error expression and alert body for a Try / Catch scope.
HTML email table styler
Column headers and a colour, as an inline-styled email table.
OData filter query builder
Conditions plus $select, $orderby and $top, as an OData query.
FetchXML builder
Dataverse's own query language, for List rows or Advanced Find.
Browse every tool →
All twelve free Power Platform tools on one page.