SharePoint Online: How to Apply Column Formatting?

Column Formatting in SharePoint Online
Column formatting in SharePoint Online modern lists and libraries customizes the field's appearance based on its value. In the past, We used SharePoint Designer and jQuery-CSS methods to format columns. But now in SharePoint Online we can apply formatting to columns with JSON.

How to Apply Column Formatting in SharePoint Online List?
Column formatting in SharePoint Online Choice, Yes/No, Date columns can be applied with few clicks without even JSON knowledge. Here is how we can use column formatting in SharePoint Online list:
  • To apply conditional formatting on a column in SharePoint Online list or library, Click on a column header, select Column settings from the menu, and then click Format this column
    column formatting sharepoint online list
  • The Format column panel will open. Click on "Edit Template" link
    sharepoint online column formatting
  • Since this is a choice column, SharePoint displays a list of all choices with a little color palette icon. Select colors for different choice values and click on apply.
    column formatting in sharepoint online
  • SharePoint Online automatically generates the JSON template to your list column and applies. Advanced mode link in the wizard lets you update the JSON directly. Here is the result:
    sharepoint online list column formatting
To set column format using PowerShell, refer: How to Set Column Format in SharePoint Online using PowerShell?

SharePoint Online Column Formatting Examples
You can use these custom column formatting examples using JSON to apply formatting on any column in SharePoint Online list or library.
SharePoint Online: How to Apply Column Formatting? SharePoint Online: How to Apply Column Formatting? Reviewed by Salaudeen Rajack on November 09, 2018 Rating: 5

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.