How to get an ICS file from a modern list item

With classic SharePoint there was a calendar template that could be connected to Outlook and had the possibility to generate ICS files for each one of the events. List have evolved since the old days of SharePoint 2007 and with the modern SharePoint and Microsoft Lists it is possible to transform any list into a calendar view, even the ones that were not designed with that primary goal in mind.

The flexibility provided by the modern lists is great, however it’s no longer possible to connect them to Outlook or to download an ICS file to add the event to a personal calendar.

In this article I’ll explain you how to get an ICS file that you can use in your personal Outlook calendar from any list using Power Automate integrated with Microsoft Lists.

(more…)

By João Ferreira Oct 7, 2022 Microsoft Lists, SharePoint 0 Comments

Where are Microsoft Lists stored?

Microsoft Lists is a new application that’s been added to Microsoft 365 to modernize the lists available in SharePoint and recently became available for consumer users with an MSA account.

With two different versions of Microsoft Lists it is important to know where the data gets store depending on the options that you choose when using the application.

(more…)

By João Ferreira Feb 25, 2022 Microsoft Lists, SharePoint 4 Comments

How to create a Kanban board using Microsoft Lists

A Kanban board is a tool created for agile project development that is now available at your fingertips in Microsoft Lists, providing you a better interface to manage work at personal or organizational level.

The new board view provides an interface to that allows you so visualize the various stages of any type of data stored in Microsoft Lists, while at the same time allows you to move them across stages by dragging and dropping items into different buckets.

(more…)

By João Ferreira Feb 1, 2022 Microsoft Lists, SharePoint 15 Comments

How to clear date time value from a list using column formatting

Deleting a date column value in Microsoft Lists and SharePoint lists without using the item form is an impossible task as this column type needs to receive a date in a specific format and does not accept empty values.

With column formatting however it is possible to workaround this limitation and hide the date when it is not needed, in this article I’ll show you a possible solution for it.

(more…)

By João Ferreira Nov 21, 2021 Microsoft Lists, SharePoint 0 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.

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

(more…)

By João Ferreira Feb 2, 2021 Microsoft Lists, SharePoint 3 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.

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

(more…)

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

How to define a modern calendar view as default view

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.

(more…)

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

How to create a list calendar view

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!

(more…)

By João Ferreira Jan 10, 2021 Microsoft Lists, SharePoint 4 Comments