SOLVED

SharePoint View formatting incorrect when first landing on the list

Brass Contributor

I have a SharePoint list where I have applied a formatting view. It displays the row either Red, Orange, Yellow, Green depending on a date field. I have the same formatting view on 2 different views, and all columns required in the formatting view are displayed in the views.

 

However, when I first hit the default view everything is green. If I switch the view from one to another, and then switch back again, the view shows the correct colours for the correct rows.

 

Is there a known bug regarding timing issues of loading the view format? Could there be an issue with my view template?

 

 

5 Replies
best response confirmed by Paul Matthews (Brass Contributor)
Solution
Ey Paul,
All the times I have use the view formatting in modern SPO, I have not face the issue you are mentioning here so it could be something to the JSON you have generated or specific to your tenant

Hi Juan,

 You might be right. I have taken a pnp template of the list and applied to a different tenant, and added some data.

Clicking around this new tenant, doesn't seem to be affecting the view formatting.

 

Thanks. Looks like I need to make a support call to Microsoft, for my original tenant.

I was wrong, it is happening on other tenants too, but the results are not all green. But they are wrong.

 

My Json is below.

{
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$Advice_x0020_Status] == 'Fed back','',if([$Decision_x0020_deadline] < @now, 'ms-fontColor-neutralSecondary ms-fontColor-redDark ms-fontSize-mPlus ms-fontWeight-bold sp-field-severity--blocked',if([$Decision_x0020_deadline] <= @now + 604800000,'sp-field-severity--severeWarning ms-fontColor-neutralSecondary ms-fontWeight-bold',if([$Decision_x0020_deadline] <= @now + 2419000000,'sp-field-severity--warning','sp-field-severity--good ms-fontColor-neutralSecondary'))))"
}

 

Its as if @now is not registering properly at load. But when you switch view, because it is a partial load it has the @now value.  I have now logged a call with Microsoft. Will update with answers.

@Paul Matthews I'm experiencing this issue as well and wondering if there was ever a workaround other than telling my users to "reload the page until it works".

@sgrams wow this is an old post.

 

Are you in the UK? I found the problem lies with the locale. Never got a solution though.

https://cann0nf0dder.wordpress.com/2019/03/09/sharepoint-online-custom-format-view-issue-with-now-an... 

 

Unfortunately that is the last time I actually did any work in regards to list formatting in SharePoint. I mainly work in Azure now.

1 best response

Accepted Solutions
best response confirmed by Paul Matthews (Brass Contributor)
Solution
Ey Paul,
All the times I have use the view formatting in modern SPO, I have not face the issue you are mentioning here so it could be something to the JSON you have generated or specific to your tenant

View solution in original post