Enhancing Data Management with Microsoft Lists Forms and Form Formatting

Microsoft Lists is a great tool for data collection in your organization. With the introduction of Microsoft Lists Forms, the process has been refined, offering a more targeted and user-centric approach. A key advantage of this new feature is the selective exposure of fields to users, safeguarding the full data schema of your list.

Despite this advancement, the feature does not differentiate the data input by the user from the subsequent additions made by someone with full list access. The fields are displayed side by side, which can lead to a mix-up of user-input data with that intended for the list owner.

Enhancing Data Management with Microsoft Lists Forms and Form Formatting


The Column Type Checklist for Microsoft Lists Forms

Microsoft Lists has introduced a new feature that streamlines the process of creating and managing lists: Microsoft Lists Forms. This addition is a significant step forward, enhancing the functionality of Microsoft Lists by providing a more intuitive and user-friendly interface to add data to the lists.

However, it’s important to note that not all column types available in Microsoft Lists are currently supported in Microsoft Lists Forms. This limitation is something to keep in mind when designing your forms.

Microsoft Lists Forms - Column Type checklist


Microsoft Lists Forms: Your Step-by-Step Starter Guide

Do you know that you can also use Microsoft Lists to create and share custom forms, such as registration forms, surveys or even quizzes? With Microsoft Lists Forms, you can easily design and distribute forms in your organization to collect feedback, opinions, or answers from your audience.

Microsoft Lists Forms is a new feature that was just released for Microsoft 365 users. It can be compared to Microsoft Forms, however, unlike Microsoft Forms, Microsoft Lists Forms integrates seamlessly with Microsoft Lists and allows you to create forms from existing list data or from scratch in minutes.

Microsoft Lists Forms - Step-by-Step Starter Guide


How to Use a Choice Field in a Lookup Column Using SharePoint and Microsoft Lists

SharePoint and Microsoft Lists are powerful tools for creating and managing data in various scenarios. One of the features that they offer is the ability to create lookup columns, which allow you to reference data from another list in your site. This can be useful for creating relationships between different types of data, such as customers and orders, products and categories, or employees and projects.

However, not all column types can be used as lookup fields. One of the column types that is not supported by default is the choice column, which lets you create a drop-down list of predefined options for your users to select from.

Choice Field in a Lookup Column Using SharePoint and Microsoft Lists


How to hide the unassigned items bucket from the board view in Microsoft Lists

Microsoft Lists is a great tool for creating and managing lists of data, tasks, events, and more. One of the features of Microsoft Lists is the ability to create a board view based on choice columns. This allows you to group and visualize your list items by different categories, such as status, priority, or owner.

However, there is a default bucket that is always visible in the board view, even if the column you selected to be used as the buckets is defined as mandatory. This bucket is called “Unassigned items” and it shows the items that have no value for the choice column. This can be annoying and confusing, especially if you have a large list with many items and buckets.

Unassigned items bucket in Microsoft Lists board view


How to Switch from Star Rating to Like Rating in SharePoint and Microsoft Lists

In my previous post, I wrote about how an old and mostly unknown column type in SharePoint and Microsoft Lists made a comeback and is now fully integrated in the Lists features without tricks and workarounds to make it available. This column type is the rating column, which allows users to rate items in a list using stars or likes.

By default, the rating column is created with a star rating that goes from 0 to 5. However, it can be changed after the column is created to a like rating. A like rating is a simple binary option that lets users indicate whether they like or dislike an item in a list.

Microsoft Lists Like column


How to Create Ratings Columns in Microsoft Lists with the New UI

If you are a fan of Microsoft Lists, you might have noticed a new feature that makes it easier to add ratings columns to your lists. Ratings columns allow you to collect feedback from your users or team members in the form of stars or thumbs up/down. They are a great way to measure satisfaction, popularity, or quality of your list items.

In the past, adding ratings columns to your lists was not a straightforward process. You had to either go to the classic list settings and enable ratings from there, or use PowerShell to activate ratings on modern communication sites. I wrote about this limitation in a previous blog post.

Microsoft Lists Rating Column


How to Use Microsoft Lists Image Columns in Adaptive Cards

Adaptive cards are a great way to create interactive and engaging experiences for your users in Microsoft 365. You can use adaptive cards to display data from various sources, such as SharePoint and Microsoft Lists, in a rich and customizable way.

However, using images stored in SharePoint in adaptive cards is not an easy task, as images can be stored in different locations with different ways to access them. For example, you may want to use an image, stored in a list image column, but how do you get the direct link to the image file that can be rendered in the adaptive card?

Microsoft Lists Image Columns in Adaptive Cards


How to Add an Image to a Microsoft Lists Image column using Power Automate

In a previous post, I wrote about the changes Microsoft did to the Image column in Microsoft Lists and how that change had an impact on how things work now in SharePoint.

In this article, I will show you how to bypass a limitation of the Power Automate connector, which does not support the Image column from the UI yet. The solution is to use the SharePoint REST API to fill in the field as a workaround.

Microsoft Image Column Power Automate


How to Turn Off Attachments in Microsoft Lists

Microsoft Lists is a powerful tool that lets you create and manage lists of data, such as tasks, issues, contacts, inventory, and more. One of the features of Microsoft Lists is the ability to add attachments to list items, such as documents, images, or other files. This can be useful when you want to provide additional information or context for your list items.

However, attachments in Microsoft Lists are not meant to be used as a replacement for the SharePoint document libraries. There are some limitations and drawbacks of using attachments in Microsoft Lists that you should be aware of:

Disable Microsoft Lists Attachments


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.