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.
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.
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, 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.
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.
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.
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.
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.
Column formatting is a neat feature that allows you to transform the data displayed in a column using a combination of HTML and JSON, making the data look a lot nicer.
By default, lists allow to change the column type, but unfortunately this is not available to all column types and hyperlinks are not supported. Thankfully we now have column formatting and in this article, I will show you how you can easily convert a link stored in plain text into an hyperlink.
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.
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.
Found my content useful?
Buy Me a Beer
HANDS ON SharePoint
HANDS ON Teams
HANDS ON Lists
HANDS ON tek
M365 Admin
