Microsoft and some amazing contributors have given us the ability to format our list columns in Modern Lists & Libraries to provide a great user experience to our users when viewing lists.
To do this, you construct a JSON object that describes the elements that are displayed when a field is included in a list view, and the styles to be applied to those elements.
Luckily for us, most of the work is already done and all we have to do is copy and paste the JSON for the format we want from the Git repository. It’s as simple as going to your List column –> Column settings –> “Format this column” option and pasting in the JSON that has already been constructed by the contributors.
I put this blog together as mostly a quick reference to myself so I can quickly choose a list column user experience to give to my clients based on a sample image that the column format does. Credit to the open source contributors for developing this JSON.
Smiley faces for good quiz results
Show trending up/trending down icons
Highlight the current user
Person Mail To Link
Display a person’s profile picture in a circle
Display a picture column as a circle
Conditional formatting based on the value in a text or choice field
Formatting an ISBN (text column) to book cover image. Images are retrieved by calling Open Library Covers API
Traffic Light (Red-Yellow-Green) Status Indicator
Strikethrough on Completion
Formatting column with long text to multiple-line with word wrap.
Formatting Yes/No field to check mark based on the value in the field
Yes/No Column Check Mark