Create solutions for Microsoft Teams using Microsoft Lists

Microsoft Lists is revolutionizing the classic lists from SharePoint, bringing new configuration and customization options that allow any user to transform tabular data into things like To Do lists or Kanban boards without the need of writing code.

I’ve been doing a session where I explain how to take advantage of Microsoft Lists to implement complete solutions for Microsoft Teams and in this blog post you will be able to find all the list formatting shown during my sessions.

Microsoft Lists formatting

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 3

After all the work you’ve done to implement the To Do list in Microsoft Lists is a bit disappointing not being able to share it with others.

If you are reading this article after going through the implementation or if you jumped all the configuration steps directly to here let me tell you that once you execute the code I’m providing in this article, all users will be able to take advantage of your new To Do list.

To Do list for SharePoint and Microsoft Lists

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 2

With a custom view formatting you can completely transform the look and feel of a list making it work almost as a standalone application.

If you have done all the steps explained in the first part of this article now it is time to improve the layout and the interaction of users with your To Do list.

To Do list for SharePoint and Microsoft Lists

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 1

The Microsoft ecosystem has plenty of options for users to store their tasks, Microsoft To Do, Planer and the new Tasks application available in Microsoft Teams are all valid options.

Microsoft Lists on the other hand can be also an option, however there are no readymade templates from Microsoft to create a simple To Do list with an appealing layout.

To Do list for SharePoint and Microsoft Lists

(more…)

Fix view formatting not showing all items

View formatting allows you transform the way data is displayed in a list using a mix of JSON and HTML, with both together you will be able to create new layouts and even new functionalities for your lists.

Despite all this power there is a known bug that prevents the list from showing more than 30 items once the formatting is applied to a list view.

Float left

(more…)

How to format a group header to display the week day in Microsoft Lists

While working with Microsoft lists the other day came up with a solution to create a custom list view to display the items created during the current week, before jumping into this article I recommend you have a look to the original post here, to get familiar with this concept.

In this post I’ll show how to format the view group headers using a custom list formatting that shows the day of the week and the number of items created.

How to format a group header to display the week day in Microsoft Lists

(more…)

How to create a current week view in Microsoft Lists

Creating views in Microsoft Lists is a straightforward process and it can be done using the UI to apply filters, group elements or even order the items as you wish. Despite the simplicity you can go a step further and use expressions and functions to display your data in different formats and create advanced views.

In this article you will learn how to create a view to filter the items created in the current week from Monday to Sunday.

Week View Microsoft Lists

(more…)

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…)

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…)

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…)


I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.