How to create a Kanban board using Microsoft Lists

By Feb 1, 2022 Microsoft Lists, SharePoint 15 Comments

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.

Microsoft Lists Kanban board view

(more…)

How to remove a custom list template from Microsoft Lists

By Jan 13, 2022 Microsoft Lists 0 Comments

Custom list templates are a great solution to easily distribute and deploy your lists to the entire organization, however over time they may need to be removed or updated.

If a template available for your organization no longer makes sense or if you want to deploy a new version first, you should remove the existing one to prevent getting duplicates.

Remove custom list template

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 3

By Jan 12, 2022 Formatting 0 Comments

After all the work you’ve done to implement the To Do list in Microsoft Lists is a bit disappointing not being able to share it with others.

If you are reading this article after going through the implementation or if you jumped all the configuration steps directly to here let me tell you that once you execute the code I’m providing in this article, all users will be able to take advantage of your new To Do list.

To Do list for SharePoint and Microsoft Lists

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 2

By Jan 12, 2022 Formatting 0 Comments

With a custom view formatting you can completely transform the look and feel of a list making it work almost as a standalone application.

If you have done all the steps explained in the first part of this article now it is time to improve the layout and the interaction of users with your To Do list.

To Do list for SharePoint and Microsoft Lists

(more…)

How to create a To Do list using SharePoint and Microsoft Lists view formatting – Part 1

By Jan 12, 2022 Formatting 4 Comments

The Microsoft ecosystem has plenty of options for users to store their tasks, Microsoft To Do, Planer and the new Tasks application available in Microsoft Teams are all valid options.

Microsoft Lists on the other hand can be also an option, however there are no readymade templates from Microsoft to create a simple To Do list with an appealing layout.

To Do list for SharePoint and Microsoft Lists

(more…)

HANDS ON tek – 10 years anniversary

By Jan 10, 2022 Events 0 Comments

January 10, 2022 marks the 10th anniversary of HANDS ON tek, a blog that I started back in 2012 to write about technology and became a central repository for solutions and articles about Microsoft 365.

To celebrate this milestone, I’m offering 10 copies of my books during the next 10 days, If you would like to get a copy of Hands-On Microsoft Lists or Hands-On Microsoft Teams continue to read the post and fill out the form.

(more…)

Fix view formatting not showing all items

By Dec 31, 2021 Formatting, Microsoft Lists 0 Comments

View formatting allows you transform the way data is displayed in a list using a mix of JSON and HTML, with both together you will be able to create new layouts and even new functionalities for your lists.

Despite all this power there is a known bug that prevents the list from showing more than 30 items once the formatting is applied to a list view.

Float left

(more…)

How to format a group header to display the week day in Microsoft Lists

By Nov 25, 2021 Formatting, Microsoft Lists 0 Comments

While working with Microsoft lists the other day came up with a solution to create a custom list view to display the items created during the current week, before jumping into this article I recommend you have a look to the original post here, to get familiar with this concept.

In this post I’ll show how to format the view group headers using a custom list formatting that shows the day of the week and the number of items created.

How to format a group header to display the week day in Microsoft Lists

(more…)

How to group items in Microsoft Lists and SharePoint list views

By Nov 25, 2021 Microsoft Lists 0 Comments

The group items feature in Microsoft Lists and SharePoint lists allows you to group items with the same value in a specific column.

Groups in Microsoft Lists are applied to a view and are displayed as collapsible elements with the group name and the number of items being displayed in the header of the section.

How to group items in Microsoft Lists and SharePoint lists

(more…)

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

By Nov 21, 2021 Microsoft Lists, SharePoint 0 Comments

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.

clear date time from SharePoint lists and Microsoft Lists

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