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

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


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.