How to hide the unassigned items bucket from the board view in Microsoft Lists

Microsoft Lists is a great tool for creating and managing lists of data, tasks, events, and more. One of the features of Microsoft Lists is the ability to create a board view based on choice columns. This allows you to group and visualize your list items by different categories, such as status, priority, or owner.

However, there is a default bucket that is always visible in the board view, even if the column you selected to be used as the buckets is defined as mandatory. This bucket is called “Unassigned items” and it shows the items that have no value for the choice column. This can be annoying and confusing, especially if you have a large list with many items and buckets.

Unassigned items bucket in Microsoft Lists board view

(more…)

New Calendar Views for Microsoft Lists

In May 2023, Microsoft announced some exciting new features for Microsoft Lists, such as custom forms, new and faster interface, rating columns by default among others. Some of these features are expected to start rolling out in February 2024, but some of them have already started to land quietly in the Lists app.

New Microsoft Calendar Views

(more…)

How to group and sort a Microsoft Lists view by month

Microsoft Lists is a powerful tool that allows you to create and manage data in various ways. You can use lists to track issues, tasks, contacts, inventory, and more. One of the features that makes lists so versatile is the ability to create different views of your data. Views let you filter, sort, group, and format your list items according to your needs and preferences.

One common scenario that many users face is how to group their list items by month. For example, you might want to see how many tasks were completed, how many issues were resolved, or how much revenue was generated in each month. Grouping by month can help you identify trends, patterns, and outliers in your data.

In this blog post, I will guide you step by step through the process of creating a list view that is grouped and sorted by month in chronological order. You will learn how to create calculated columns, use formulas, and adjust sorting options to achieve the desired result.

Group and sort a Microsoft Lists view by month

(more…)

How to create a video playlist for Stream Videos

A video playlist is a collection of videos, typically related in some way, that play in a specific order. Playlists are commonly found on video sharing platforms like YouTube and allow users to watch a series of videos without having to manually search for and select each video.

Recently SharePoint lists and Microsoft Lists got a new playlist template that can be used to create playlists of Videos hosted in SharePoint that are reproduced in the new version of Microsoft Stream.

Microsoft Lists video playlist

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


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.