Forum Discussion

pnthrzrule's avatar
pnthrzrule
Iron Contributor
Apr 24, 2020
Solved

Conditional Formatting Files Older Than Certain number of days or years

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 mo...
Document Library
files
Lists
SharePoint Online
sharepoint server
  • RobElliott's avatar
    RobElliott
    Apr 25, 2020

    Hi Michael, (pnthrzrule), 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

     

pnthrzrule's avatar
pnthrzrule
Iron Contributor
Apr 28, 2020

RobElliott 

 

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?

RobElliott's avatar
RobElliott
Silver Contributor
Apr 30, 2020

pnthrzrule  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

Resources