Understand Microsoft Lists Comments VS Conversation when using Microsoft Teams

Microsoft Lists allows you to create comments for each item and this feature comes handy for scenarios where you have multiple users reading or modifying information in the same item.

Comments are available in all versions of Microsoft Lists however when using a list in Microsoft Teams this feature and the Teams application conversation can be easily mix-up potentially leading to a loss of information.

Comments VS Conversations in Microsoft Lists

(more…)

How to install Microsoft Lists as a PWA application

A progressive web application (PWA) is by definition a software application delivered through the web built using web technologies.

Microsoft Lists is one of the first Microsoft 365 application becoming available as a PWA and in this article I’ll explain you how to get it installed to get a full experience and to get access to offline mode.

Microsoft Lists PWA application

(more…)

How to use modern lookup columns in Microsoft Lists

Lookup columns allows you to enforce a relationship between different sources of data in your data system. This feature is a simplistic version of the classic relationship between tables in a data base.

Up until recently this type of data was only available through the classic interface of SharePoint but now it’s made a debut in the modern interface of Microsoft Lists and can be used without jumping between 2 different environments.

Lookup columns

(more…)

How to create a Kanban board using Microsoft Lists

A Kanban board is a tool created for agile project development that is now available at your fingertips in Microsoft Lists, providing you a better interface to manage work at personal or organizational level.

The new board view provides an interface to that allows you so visualize the various stages of any type of data stored in Microsoft Lists, while at the same time allows you to move them across stages by dragging and dropping items into different buckets.

Microsoft Lists Kanban board view

(more…)

How to remove a custom list template from Microsoft Lists

Custom list templates are a great solution to easily distribute and deploy your lists to the entire organization, however over time they may need to be removed or updated.

If a template available for your organization no longer makes sense or if you want to deploy a new version first, you should remove the existing one to prevent getting duplicates.

Remove custom list template

(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 group items in Microsoft Lists and SharePoint list views

The group items feature in Microsoft Lists and SharePoint lists allows you to group items with the same value in a specific column.

Groups in Microsoft Lists are applied to a view and are displayed as collapsible elements with the group name and the number of items being displayed in the header of the section.

How to group items in Microsoft Lists and SharePoint lists

(more…)

How to clear date time value from a list using column formatting

Deleting a date column value in Microsoft Lists and SharePoint lists without using the item form is an impossible task as this column type needs to receive a date in a specific format and does not accept empty values.

With column formatting however it is possible to workaround this limitation and hide the date when it is not needed, in this article I’ll show you a possible solution for it.

clear date time from SharePoint lists and 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…)


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.