Posts by Joaoferreira

How to group and sort a Microsoft Lists view by month

Microsoft Lists is a powerful tool that allows you to create and manage data in various ways. You can use lists to track issues, tasks, contacts, inventory, and more. One of the features that makes lists so versatile is the ability to create different views of your data. Views let you filter, sort, group, and format your list items according to your needs and preferences.

One common scenario that many users face is how to group their list items by month. For example, you might want to see how many tasks were completed, how many issues were resolved, or how much revenue was generated in each month. Grouping by month can help you identify trends, patterns, and outliers in your data.

In this blog post, I will guide you step by step through the process of creating a list view that is grouped and sorted by month in chronological order. You will learn how to create calculated columns, use formulas, and adjust sorting options to achieve the desired result.

(more…)

By João Ferreira Jan 5, 2024 Formatting, Views 0 Comments

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

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.

(more…)

By João Ferreira Jan 4, 2024 Formatting 0 Comments

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

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.

(more…)

By João Ferreira Oct 26, 2023 Formatting 2 Comments

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

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.

(more…)

By João Ferreira Oct 12, 2023 Microsoft Lists 0 Comments

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

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.

(more…)

By João Ferreira Jun 13, 2023 Microsoft Lists 0 Comments

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

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.

(more…)

By João Ferreira May 4, 2023 Microsoft Teams 13 Comments

Revolutionizing list filtering: Introducing Microsoft Lists new filter pills!

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.

(more…)

By João Ferreira May 4, 2023 Microsoft Lists 2 Comments

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

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.

(more…)

By João Ferreira Apr 3, 2023 Formatting 0 Comments

Formatting grouped list headers with user profile pictures

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.

(more…)

By João Ferreira Feb 28, 2023 Formatting 0 Comments

How to migrate lists using PnP PowerShell

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.

(more…)

By João Ferreira Feb 27, 2023 PowerShell 0 Comments