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


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


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


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


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


Define lists gallery view as default view in SharePoint and Microsoft Lists

Views in SharePoint lists and Microsoft Lists allow you to format and pre-filter the information that is displayed in the lists.

One of the options available out of the box to use as a view is the gallery layout that transforms any list row into a tile featuring image and person columns.

Microsoft Lists gallery view


How to rename the Title column in SharePoint lists and Microsoft Lists

The Title column was one of the major pain points SharePoint lists had in the past as it was impossible to remove it, or even rename to adjust it to the context of the list.

Since July 2020 and with the release of Microsoft Lists is now possible to easily rename the Title column in 3 easy steps.

Rename Title column


Format an image column with preview in Microsoft Lists and SharePoint

Microsoft Lists and SharePoint lists now include a column type dedicated exclusively to images that allows a user to upload an image directly to the form and displays a small thumbnail of the image in the list view.

This was a massive improvement when compared with the classic hyperlink/picture column type and in this article, I will show you how to take the new Image column type to the next using column formatting.

Custom column formatting Microsoft Lists and SharePoint


Create Microsoft Lists and SharePoint custom forms without using Power Apps

List forms are generated automatically when a new list is created but sometimes it simply does not meet the business requirements and when that happens you need to create custom forms.

SharePoint list forms can be customized since forever and if you know the platform for a log time, things like InfoPath and Power Apps might sound familiar to you as these were the tools used to build custom forms.

Microsoft Lists and SharePoint custom form


Meet the new Microsoft Lists application for iOS

Microsoft Lists continues the quest to conquer the world of lightweight databases, after being available for the web and Microsoft Teams now it gets a dedicated app for iOS that will allow you to carry your lists in your pocket.

The Microsoft Lists application for iOS provides you access to the same features you already know from the web and Teams versions and as a bonus you will get a new template to create lists to manage your expenses from your phone.

Microsoft Lists for iOS


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.