How to concatenate a column value using column formatting

When formatting list columns in SharePoint and Microsoft Lists you might have the need to concatenate a column value to modify value in the new structure representing the information.

With list formatting you can concatenate a column value with other columns or strings using an operator, in this article I will show you how to concatenate a values to get a different value in the column using the YouTube thumbnail formatting from one of my previous articles.

Concatenate List values

(more…)

By João Ferreira Feb 9, 2021 Formatting 0 Comments

How to split a column value using column formatting

When formatting list columns in SharePoint and Microsoft Lists you might have the need to split a column value to use just part of in the new structure representing the information.

With Microsoft Lists there is no split method available to be used, however with some creativity is possible easily split the column and use just part of the value.

Split a column value in SharePoint and Microsoft Lists column formatting

(more…)

By João Ferreira Feb 8, 2021 Formatting 0 Comments

Transform hyperlink columns into clickable video thumbnails

The possibilities to transform data in SharePoint and Microsoft Lists are endless with the column formatting, and today I will show you an awesome example that transforms hyperlinks into a YouTube clickable video thumbnail with preview.

The example described here is generic and the only requirement it has is the existence of a hyperlink column with an YouTube video link stored in it.

video thumbnail

(more…)

By João Ferreira Feb 7, 2021 Formatting 0 Comments

Convert a single line of text column to hyperlink using SharePoint and Microsoft Lists column formatting

Column formatting is a neat feature that allows you to transform the data displayed in a column using a combination of HTML and JSON, making the data look a lot nicer.

By default, lists allow to change the column type, but unfortunately this is not available to all column types and hyperlinks are not supported. Thankfully we now have column formatting and in this article, I will show you how you can easily convert a link stored in plain text into an hyperlink.

single line of text formatting