Convert a single line of text column to hyperlink using SharePoint and Microsoft Lists column formatting

By Feb 3, 2021 Formatting 11 Comments

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.

single line of text formatting

(more…)

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

By Feb 2, 2021 Microsoft Lists, SharePoint 0 Comments

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

(more…)

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

By Feb 2, 2021 Microsoft Lists, SharePoint 3 Comments

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

(more…)

Format an image column with preview in Microsoft Lists and SharePoint

By Jan 24, 2021 Microsoft Lists, SharePoint 11 Comments

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

(more…)

Create Microsoft Lists and SharePoint custom forms without using Power Apps

By Jan 24, 2021 Microsoft Lists, SharePoint 11 Comments

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

(more…)

Meet the new Microsoft Lists application for iOS

By Jan 20, 2021 Microsoft Lists 0 Comments

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

(more…)

How to define a modern calendar view as default view

By Jan 17, 2021 Microsoft Lists, SharePoint 2 Comments

As seen in the previous article SharePoint and Microsoft Lists now have a modern calendar view that can be applied to any list.

While trying to define the calendar as a default view I’ve found two blocker issues and end up with a broken calendar not showing any information, thankfully PowerShell can always be used in situations like this when the interface does not fulfill the expectations.

Default calendar view

(more…)

How to create a list calendar view

By Jan 10, 2021 Microsoft Lists, SharePoint 4 Comments

After years dealing with the classic SharePoint calendar finally Microsoft has made the modern calendar available for Microsoft Lists and SharePoint.

If you were used to the classic calendar you must know that the new approach to the calendar is completely different and there is no such thing as a calendar template.

This means that any existing list can suddenly become a calendar, the only requirement is the existence of a date column in the list!

Microsoft Lists Calendar view

(more…)

Microsoft Lists for administrators – The ultimate guide

By Jan 7, 2021 Microsoft Lists, SharePoint 4 Comments

Microsoft Lists is the new kid on the block in the Microsoft 365 ecosystem with users and administrators still discovering all the new features that were brought by the application to SharePoint lists.

Despite being new features you as an administrator have control to decide which of them are available to the end users, and things like personal lists, list templates and comments can be enabled or disabled as you wish.

Microsoft Lists for administrators - The ultimate guide

(more…)

How to save a Microsoft Lists personal lists as a template

By Nov 1, 2020 Microsoft Lists, SharePoint 0 Comments

Microsoft Lists has introduced the concept of personal lists that are stored in the user my site and are only visible to the user.

In this article I’ll explain you step by step how you can use an existent personal list to create a template that you can later reuse to create new lists.

Microsoft Lists template

(more…)

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.