JSON formatting - users need to reload the library view manually

%3CLINGO-SUB%20id%3D%22lingo-sub-2271578%22%20slang%3D%22en-US%22%3EJSON%20formatting%20-%20users%20need%20to%20reload%20the%20library%20view%20manually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20april%202020%2C%20I%20have%20created%20JSON%20list%20formatting%20in%20one%20of%20my%20Document%20Library%20that%20would%20change%20the%20color%20of%20the%20item%20title%20%5B%24FileLeafRef%5D%20if%20the%20number%20of%20child%20items%20%5B%24ItemChildCount%5D%20if%20greater%20than%200.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAll%20was%20perfect%2C%20but%20since%20some%20weeks%2C%20the%20JSON%20script%20rendering%20is%20OK%2C%20but%20the%20library%20view%20is%20not%20getting%20refreshed.%20Customers%20need%20to%20reload%20the%20library%20manually%20to%20see%20the%20change.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20have%20seen%20the%20following%20change%20in%20our%20JSON%20script%20(abstract%20below)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EBefore%20Microsoft%20update%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3E%7B%0A%20%20%22schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fview-formatting.schema.json%22%2C%0A%20%20%22debugMode%22%3A%20true%2C%0A%20%20%22hideSelection%22%3A%20true%2C%0A%20%20%22hideColumnHeader%22%3A%20true%2C%0A%20%20%22rowFormatter%22%3A%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAfter%20Microsoft%20Update%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3E%7B%0A%20%20%22%24schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fv2%2Frow-formatting.schema.json%22%2C%0A%20%20%22schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fview-formatting.schema.json%22%2C%0A%20%20%22debugMode%22%3A%20true%2C%0A%20%20%22hideSelection%22%3A%20true%2C%0A%20%20%22hideColumnHeader%22%3A%20true%2C%0A%20%20%22rowFormatter%22%3A%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWho%20knows%20if%20Microsoft%20will%20fix%20this%20bug%20and%20when%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2271650%22%20slang%3D%22en-US%22%3ERe%3A%20JSON%20formatting%20-%20users%20need%20to%20reload%20the%20library%20view%20manually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271650%22%20slang%3D%22en-US%22%3EDifficult%20to%20answer%20this%20one%2C%20best%20you%20can%20do%20here%20is%20open%20a%20support%20ticket%20to%20notify%20this%20issue.%20Hopefully%20Microsoft%20can%20move%20fast%20on%20the%20issue%2C%20but%20it's%20not%20guaranteed%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

In april 2020, I have created JSON list formatting in one of my Document Library that would change the color of the item title [$FileLeafRef] if the number of child items [$ItemChildCount] if greater than 0.

 

All was perfect, but since some weeks, the JSON script rendering is OK, but the library view is not getting refreshed. Customers need to reload the library manually to see the change.

 

We have seen the following change in our JSON script (abstract below)

Before Microsoft update

 

 

 

{
  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "debugMode": true,
  "hideSelection": true,
  "hideColumnHeader": true,
  "rowFormatter":

 

 

 

After Microsoft Update

 

 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "debugMode": true,
  "hideSelection": true,
  "hideColumnHeader": true,
  "rowFormatter":

 

 

 

Who knows if Microsoft will fix this bug and when?

 

4 Replies
Difficult to answer this one, best you can do here is open a support ticket to notify this issue. Hopefully Microsoft can move fast on the issue, but it's not guaranteed

Hello @Juan Carlos González Martín 

Thank you for your message. I already try to open a support ticket to Microsoft 365 support, unfortunately, the answers was "We provide no support for JSON Scripts and code at Microsoft 365. please ask Microsoft Tech Community" !!!

 

Best regards,

Pierre-Yves

That's a shame :-(. I will insist on that and also try to report the problem you are having through GitHub over here where there are View formatting samples: https://github.com/pnp/List-Formatting
Thank you Juan for the good idea. I will try :)