How to detect the length of a string with Microsoft Lists formatting

By Jan 4, 2024 Formatting 0 Comments

One of the things that I like to do at the beginning of every year is to review some of my Microsoft Lists and create new views or refine some of the existing ones. This year was no exception, and while I was working on one of my lists, I decided to fix a problem (more about it here) that had been bothering me for a long time but in the process, I found another annoying issue.

My goal was to split a string and I jumped immediately into the length function; however this function only measures the size of an array, not the length of a string. This means that if you want to apply some conditional formatting based on the number of characters in a text field, or if you want to split the string in half you are out of luck.

Microsoft Lists formatting field length

(more…)

How to fix and format an image column with preview in Microsoft Lists and SharePoint

By Oct 26, 2023 Formatting 2 Comments

One of the first column formatting samples I did for SharePoint and Microsoft Lists was a lightbox to preview the image stored in the Image field, this way the user is able to see the picture in high resolution without the need to download it or open it in another tab.

This sample is available in the PnP GitHub repo and had several revisions, unfortunately all of them stopped working as some of the image field properties are no longer there. Thankfully there is a new method to get thumbnails from the image that can be used to replace the old properties.

Fix Microsoft Lists image preview

(more…)

How to fix a missing video duration in a playlist in SharePoint and Microsoft Lists

By Oct 12, 2023 Microsoft Lists 0 Comments

If you’ve been busy creating your playlists, you might have noticed a little glitch in the system. Normally, adding videos to your playlist in SharePoint or Microsoft Lists is a piece of cake, and the system automatically adds to the list how long each video is.

But every once in a while, SharePoint decides to go on strike, and your playlist shows videos with a missing duration. Frustrating, right? Don’t worry; I’m going to show a straightforward fix for you.

Fix Microsoft List missing duration

(more…)

Boost Collaboration and Decision-making with the Microsoft Lists Rating Feature

By Jun 13, 2023 Microsoft Lists 0 Comments

Microsoft Lists is a versatile application that empowers teams to organize, track, and share information effectively. Within Lists, there is a valuable feature called the rating, which allows users to rate and provide feedback on list items.

This blog post will guide you through the process of enabling the SharePoint and Microsoft Lists rating feature and adding it to your lists, enhancing collaboration and facilitating better decision-making within your team.

Microsoft Lists ratings

(more…)

Revolutionize your data collection: The latest update to Microsoft List forms

By May 4, 2023 Microsoft Teams 13 Comments

Microsoft Lists is a powerful tool designed to help teams stay organized and work more efficiently. Whether you’re tracking tasks, sharing resources, or organizing information, Lists can help streamline your workflow and keep everyone on the same page.

One of the latest announcements to Microsoft Lists is an enhanced forms experience. With this update, creating and managing forms will be easier than ever before. Forms can be designed to look clean and professional, with custom logos, names, and descriptions. And with user-friendly questions instead of column names, respondents can easily understand what information is being requested.

Microsoft Lists new forms

(more…)

Revolutionizing list filtering: Introducing Microsoft Lists new filter pills!

By May 4, 2023 Microsoft Lists 2 Comments

If you’re a SharePoint or a Microsoft Lists user, you’ll be pleased to know that the platform has just received a new filtering feature that is set to make your life a lot easier. With the introduction of “filter pills”, it’s now easier than ever to filter your lists and find the items you need.

This new filtering system is a great addition to Microsoft Lists, and it’s likely to be particularly useful for those who work with large lists or who regularly need to filter their data. With the ability to quickly and easily see which filters are applied and remove them as needed, this new feature is sure to save users time and frustration.

Microsoft Lists filter pills

(more…)

Mastering list view formatting: How to format selected items in Microsoft Lists and SharePoint

By Apr 3, 2023 Formatting 0 Comments

Lists can help you to keep track of tasks, projects, and important information. However, as lists grow larger and more complex, it can be challenging to navigate and make sense of the data. That’s where list view formatting comes in.

With the ability to customize how lists are displayed, list view formatting allows you to present data in a more meaningful and visually appealing way. One of the most useful features of list view formatting is the ability to highlight selected items, providing an instant visual cue that draws the user’s attention to important information.

This blog post will guide you through formatting selected items in views, using two different examples to illustrate the process.

How to format selected items in Microsoft Lists and SharePoint

(more…)

Formatting grouped list headers with user profile pictures

By Feb 28, 2023 Formatting 0 Comments

Grouping a list in SharePoint or Microsoft Lists, makes it easier to view and analyze the data as the information is aggregated by one column.

In this article I’m explaining how you can group a list and format the header of the group with the creator name and profile picture to make it easier to find the information.

Formatting grouped list headers with user profile pictures

(more…)

How to migrate lists using PnP PowerShell

By Feb 27, 2023 PowerShell 0 Comments

Lists migration in SharePoint and Microsoft Lists is the process of moving lists from one site or tenant to another one.

Migrations can be necessary for a variety of reasons, including upgrading an existing intranet, merging multiple site collections, or consolidating data from different sites. The migration process can be complex and time-consuming, as it requires careful planning and execution to ensure that all data is accurately transferred and that there is no loss or corruption of information.

Migrate SharePoint lists using PnP PowerShell

(more…)

How to modify a list column name in Microsoft Lists

By Feb 12, 2023 Microsoft Lists 0 Comments

A column name in a list is used to help users to identify what type of information is store in each cell. Throughout the live of projects in SharePoint and Microsoft Lists requirements can change or you can have made a typo when creating the lists.

If you face yourself in this situation, in this article I’m showing you how to easily modify the column name and what things should you take into consideration when doing it.

Rename Microsoft Lists column

(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.