Archive for June, 2017

As most of you know, I am creating quite a few training courses around SharePoint, PowerShell and Office 365 on Pluralsight! I just received an email that they are running an awesome offer until end of month, where you can get a Free Visa Gift Card valued at 10$ if you sign up for a monthly subscription, or 30$ if you sign up for a yearly subscription! Click the banner below to learn everything about the offer:

Free Visa Gift Card

There are currently over 5000 courses in the Pluralsight library and more than 40 hours of SharePoint 2016 content, so you definitely have a lot to learn! If your goal is to get certified, check out some of the free certification guides that I have built:

5/5 (1)

Please rate this

Microsoft just published a new support article stating that you cannot use calculated fields to display HTML anymore. I know a lot of people were using this to for example show KPIs, or do some conditional formatting. This change was announced on June 13th 2017 and taking effect as of June 13th 2017 , so not giving companies a lot of time before things start breaking … however an Administrator can open a support ticket and extend this functionality until September 10th , when this will completely stop working.

For SharePoint On-Premises, Microsoft will include a new Web-Application level setting in SharePoint 2013/2016 starting in the July 2017 PU which will allow you to either enable or block this feature at the Web Application level. Here is the full announcement:

Calculated Fields

In Microsoft SharePoint lists and libraries, calculated fields that are running in the classic UI mode can be used to display results based on Excel-like formulas. This is a long standing capability, and is documented in Calculate data in lists or libraries.

Some users have added HTML markup or script elements to calculated fields. This is an undocumented use of the feature, and we will begin blocking execution of custom markup in calculated fields in SharePoint Online from June 13, 2017 onwards. We are also providing this as a configurable option for on-premises in SharePoint Server 2016 and SharePoint Server 2013 via the June 2017 and subsequent Public Updates.

More Information

SharePoint Online

We are changing calculated fields to escape special characters. In some circumstances, this mean that calculated fields that contain any unsupported markup will not display any value. Instead, they’ll be blank in the list view.

This change will take effect on June 13, 2017. Administrators can request an extension through September 10, 2017 at the latest. During this time, special characters will not be escaped in calculated fields. This request can be submitted through Microsoft Support. However, beginning September 10, 2017, all unsupported markup will be ignored.

SharePoint Server 2013 and SharePoint Server 2016

The June 2017 Public Update (PU), and subsequent PUs will include a new web application setting that’s called CustomMarkupInCalculatedFieldDisabled. This setting will enable an on-premises administrator to configure whether or not calculated fields in a given web application will escape special characters.

Here’s the default behavior for existing and new web applications at the time of the update installation.

Web app type Default setting
Newly created web app after the update is installed Escape special characters in calculated fields
Existing web app after the update is installed Don’t escape special characters in calculated fields

You can also view it on Microsoft Support Here: Handling HTML markup in SharePoint calculated fields. Does this change affect you or your users? How do you plan to go around it for those different needs? Will you be requesting an extension until September 10th?

Share the info the comments so we can all help each other and make sure to share this on Social Media so your colleagues will also be aware of the change!

Follow me on Social Media and Share this article with your friends!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (4)

Please rate this