Posts by Joaoferreira

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

By João Ferreira Nov 25, 2021 Formatting, Microsoft Lists 0 Comments

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

By João Ferreira Nov 25, 2021 Microsoft Lists 0 Comments

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

By João Ferreira Nov 21, 2021 Microsoft Lists, SharePoint 0 Comments

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

By João Ferreira Nov 19, 2021 Formatting, Microsoft Lists 11 Comments

Microsoft Lists is coming to Android – Learn how to get access to the Private Preview

Microsoft has released Microsoft Lists for iOS devices in the beginning of the year and this week at Ignite a new version compatible with Android devices just got announced.

The mobile version of Microsoft Lists gives you access to data while on the go with an interface adjusted to the small screens making the interaction with data a pleasant experience.

Microsoft Lists for Android

(more…)

By João Ferreira Nov 3, 2021 Microsoft Lists 2 Comments

How to add custom list templates to Microsoft Lists

Microsoft Lists, an evolution of SharePoint lists was released with several predefined templates that can be used as a starting point when creating a new list. Despite including templates this new platform was missing the list template feature that was available in the classic world of SharePoint.

List templates in Microsoft Lists can only be created by the global administrator and the process is only available using PowerShell.

Add custom list templates to Microsoft Lists

(more…)

By João Ferreira Sep 28, 2021 Microsoft Lists 1 Comment

Hands-On Microsoft Lists book is now available

I’m happy to announce that today the book I co-authored with Rene Modery about Microsoft Lists is getting published.

Microsoft Lists is an extremely flexible and powerful platform for creating custom data models. Hands-On Microsoft Lists is an easy-to-read guide for those who want to get started with Lists, as well as those who are already familiar with the basic concepts and want to create custom and flexible Lists that are easily available through a web interface.

Hands-On Microsoft Lists book

(more…)

By João Ferreira Jul 16, 2021 Microsoft Lists 0 Comments

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

By João Ferreira Feb 9, 2021 Formatting 0 Comments

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

By João Ferreira Feb 8, 2021 Formatting 0 Comments

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

By João Ferreira Feb 7, 2021 Formatting 0 Comments

João Ferreira

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.