Posts by Joaoferreira

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

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

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

By João Ferreira Feb 3, 2021 Formatting 11 Comments

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

(more…)

By João Ferreira Feb 2, 2021 Microsoft Lists, SharePoint 0 Comments

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

(more…)

By João Ferreira Feb 2, 2021 Microsoft Lists, SharePoint 2 Comments

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

(more…)

By João Ferreira Jan 24, 2021 Microsoft Lists, SharePoint 11 Comments

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

(more…)

By João Ferreira Jan 24, 2021 Microsoft Lists, SharePoint 11 Comments

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

(more…)

By João Ferreira Jan 20, 2021 Microsoft Lists 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.