Microsoft Blocked HTML Markup in SharePoint Calculated Fields

Problem
Microsoft has started blocking execution of custom markup in calculated fields in SharePoint Online from June 13, 2017 onwards.

Reference

Workaround

  • JS Link Approach – JSLink allows us to change the field formatting based on field values or custom logic. This approach may not work for calculated column and modern concept.
  • DOM Manipulation at runtime using a script editor webpart – This is a temporary solution as Microsoft is recommending users to use modern features.
  • SharePoint Framework Extension – This approach can be used only when we switch to modern concepts. We can make a ApplicationCustomizers using extension approach to derive a generic solution.

Temporary Fix for Classic Pages – DOM Manipulation at runtime

Sample Formula

Snip20170617_7

Sample JavaScript Code to add in Script Editor WebPart

Snip20170617_6.png

Advertisements

About Joseph Velliah
As a SharePoint Developer my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

Comments are closed.

%d bloggers like this: