04-24-2020 11:19 AM
Hello Everyone,
I'm aware of the new Conditional Formatting Rule builder that just dropped to my tenant last week. However, I'm wanting to implement formatting that will mark files that have a modified date 2 years or more before today.
The goal is to mark files that haven't been modified in the past 2 years (relative to today). Has anyone done this? If so can you please share the JSON? Please and Thank You!
04-25-2020 03:18 AM
SolutionHi Michael, (@Michael Malloy), yes we do this at our company. The JSON is below and subtracts 2 years (in milliseconds) from today's date. If the Modified date is older than that then the date is red, otherwise it's green:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": "=if([$Modified] <= @now-63113904000, '#c64444', '#468757')"
}
}
Rob
Los Gallardos
Microsoft Power Automate Community Super User
04-27-2020 09:18 AM
04-28-2020 07:49 AM
Also...one more question...It appears that JSON applied to a library affects ALL views. Is there a way to restrict this to just the active view to which I'm adding the JSON?
04-30-2020 08:35 AM - edited 04-30-2020 09:01 AM
@Michael Malloy sorry for the delay in replying Michael. From the menu where your views are listed, select Format current view. In the example below I've got the All items view in standard list format, but in the view that I've named Tile I've formatted the items differently with JSON:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
04-30-2020 09:58 AM
Thanks so much for the video. I swear I only applied the json (Red files older than 2 years) to only 1 view. However, for some reason, that formatting seemed to bleed over into all views. I will do some more testing. Thanks again.
04-30-2020 10:01 AM
@Michael Malloy if you apply the formatting to the column (from the column header) then it will be there in all views. If you apply formatting to the view then it won't.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
04-30-2020 10:03 AM
Ah I see! I will try that!