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.