SharePoint List Column Formatting – Part I

Many of us have used custom code to format the columns in SharePoint, either to display color-coded data or display images instead of text based on the scenario. It has often been very complex to implement the desired requirements. Microsoft has finally provided us with a column formatting feature that does not require client site programming knowledge or backend implementation knowledge. Using JSON, now we can perform Conditional Formatting, place Action links in the list, provide a Flow Button alongside each line item, and provide more enhanced Data Visualization.  Details about each of the different scenarios are provided below.

Conditional Formatting

Apply styling to a field, based on that field’s value or range of values:

Action Links

Create a hyperlink to another page or web address, based on the value in the field. For example, send an email to a user or take the user to a page based on the value in the field:

Flow Buttons

Create a button that kicks off a flow on the corresponding item:

Data Visualizations

Use icons and CSS to decorate fields with visual indications of trends and progress:

The column formatting can be applied to the list using the following steps:

  • Go to any SharePoint list in a version with this latest feature
  • Click on any of the columns, in the menu select Column Settings -> format this column
  • It will open a dialog box where the JSON can be placed

This makes the implementation very easy and changes are all client site so you don’t need to worry about re-publishing the code or saving the files.

Have questions? Need help building a scaleable platform? Send us an email at info@peters.com or call 630.832.0075 to start the conversation.

By | 2018-02-05T09:53:34+00:00 February 7th, 2018|Collaboration|Comments Off on SharePoint List Column Formatting – Part I

About the Author:

Shraddha Shah, Sr SharePoint Developer at Peters & Associates focused on developing SharePoint solutions for clients. Work with clients to understand their requirements, challenges and providing solutions in SharePoint. She has spent over 13 years in the IT and Software fields having experience in web development and SharePoint applications. Shraddha holds a M.S. in Computer Science from New York Institute of Technology, and a Bachelor of Science degree in Computer Engineering.