How to custom order playlists in Microsoft Lists

In my previous blog post I’ve explained how to create Video Playlists using the new awesome Microsoft Lists playlist template, and today I’m showing how you can tweak it a little bit to organize the videos.

By default, videos are shown in the playlist by the order they were added  without an option to sort them differently, but with a small customization this behavior can be easily modified.

Order Microsoft Lists playlist

(more…)

How to format a Microsoft Lists Calendar view

Modern SharePoint and Microsoft Lists calendar views are available for some time now and I covered the creation process already here in the blog.

What I’m explaining in this post is how you can easily format the calendar with colors to better identify the items throughout the month.

Format Microsoft Lists and SharePoint calendars

(more…)

How to create a Year view in SharePoint and Microsoft Lists

With the year starting it is time to recreate or update the systems used last year to store and manage information, and that’s exactly what I’m doing in these first days of the year.

Last year I started to use a list to manage payments and I would like to continue to use the same one this year, at the same time I would like to create year views to access the data from separate years when needed.

SharePoint and Microsoft Lists Year view

(more…)

How to get an ICS file from a modern list item

With classic SharePoint there was a calendar template that could be connected to Outlook and had the possibility to generate ICS files for each one of the events. List have evolved since the old days of SharePoint 2007 and with the modern SharePoint and Microsoft Lists it is possible to transform any list into a calendar view, even the ones that were not designed with that primary goal in mind.

The flexibility provided by the modern lists is great, however it’s no longer possible to connect them to Outlook or to download an ICS file to add the event to a personal calendar.

In this article I’ll explain you how to get an ICS file that you can use in your personal Outlook calendar from any list using Power Automate integrated with Microsoft Lists.

Get ICS from modern list templates

(more…)

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

Get Microsoft Lists for Android

With this app for Android, you will now be able to access their Microsoft Lists (including SharePoint lists) on the go anytime, anywhere by using Microsoft Lists for Android.

With Lists, you can manage events, track issues and assets, help with new-employee onboarding, and keep coordinated across inventory. With access on the go, easy sharing, and quick photo capture, you can keep everyone connected with the latest information using Microsoft Lists.

Microsoft Lists for Android

(more…)

Where are Microsoft Lists stored?

Microsoft Lists is a new application that’s been added to Microsoft 365 to modernize the lists available in SharePoint and recently became available for consumer users with an MSA account.

With two different versions of Microsoft Lists it is important to know where the data gets store depending on the options that you choose when using the application.

Microsoft Lists Storage

(more…)

How to hide Microsoft Lists columns in forms conditionally

Microsoft Lists allows you to format the forms using JSON and also allows you to show/hide columns conditionally based on the data that is stored in the item.

In this article you will learn how the conditional formulas work and how you can add them to the to list columns individually.

Conditionally display columns in Microsoft Lists

(more…)

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


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.