Loading

JSON to show colors on expired items in list

Mark Verderame

7y804

I want to turn red on items that are expired - to highlight them to staff

Here is my JSON, it is not highlighting anything. Expiration is the field name in the record.

{
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"CurrentRowClass": "=if([$Expiration] <= '@now', 'style: {color:#ff0000'} ) "
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Maha Lakshmi7y ago
Please refer this site
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-formatting-based-on-date-ranges
0
Nanddeep Nachan7y ago
Please see, if column Expiration is only Date (not Date and Time)
Instead of @now, use @today
0
Sreekanth Reddy7y ago
Hi,

Parse your json data as an object & then from the object try to apply the style after retrival.
I dont think so applying logic inside the json data is correct method.
0