Microsoft Lists – Detailed Tutorial

Have you started using Microsoft Lists Apps in Microsoft 365 or Office 365? In this tutorial, we will discuss in detail Microsoft Lists. How to use Microsoft Lists with Microsoft Teams App.

What is Microsoft Lists App?

Microsoft Lists is a Microsoft 365 app, like any other Office 365 app like Outlook, word, excel, PowerPoint, SharePoint Online, Microsoft Forms, Yammer, OneNote, etc.

We can use the Microsoft lists app to track information and organize work. It is like a SharePoint Online list. We can use Microsoft lists to track issues, assets, contacts, or inventory and we can create customizable views to view the data in a smarter way according to the business requirement. Microsoft lists also allow you to create and apply smart rules, alerts to notify.

There are also ready-made Microsoft lists templates available that you can use. Easily you can share the list with other users.

You can create a list from the Office 365 app launcher, from the mobile app, and also you can create and use Microsoft Lists within Microsoft Teams.

Not only this, you can also integrate Microsoft lists with PowerApps and Power Automate.

  • Microsoft Lists Formatting Examples

Microsoft lists release date or launch date

Microsoft announced in May 2020 about a new upcoming Office 365 app or Microsoft 365 Apps as Microsoft Lists. In July 2020, Microsoft rolled out Microsoft Lists for Targeted Release customers in Microsoft 365. And in Nov 2020, Microsoft released the Microsoft Lists app worldwide and was available in all plans like commercial, education and government.

microsoft lists release date
Microsoft lists release date

Microsoft Lists Licensing

You do not need to take any additional license or subscription if you have an Office 365 or Microsoft 365 subscription. Microsoft Lists App is available in all the Office 365 plans. You can check out the below articles for a Microsoft 365 subscription and sign up.

See also  Power Apps Filter SharePoint List [25+ Examples]

Microsoft Lists – Create a List

Let us see now, how to create a list in Microsoft Lists.

Login to Office 365 or Microsoft 365 with your Office 365 credentials. Click on the App launcher and then click on Lists like below:

microsoft lists
Microsoft lists

Then click on + New list like below:

create a list in microsoft lists
create a list in Microsoft lists

Then it will open the Create a list dialog box.

There are various options to create a list, like you can create a list from the below options:

  • Blank list: Choose if you want to create a blank list
  • From Excel: Choose if you want to create a list from an excel spreadsheet.
  • From existing list: Choose if you want to create a list from an existing list.
  • Use an existing template: You can select an existing list template to create a list.
microsoft lists templates
Microsoft Lists Templates

Here we will create a Blank list. Choose the Blank list option above.

Then it will ask you to provide the below details:

  • Name– Provide a name for the list
  • Description– Provide a list description
  • Choose a color– Choose a color for the list
  • Choose an icon– Choose an icon for the Microsoft lists
  • Save to– Save to either to My list or to a SharePoint Online site
Steps to create a list in Microsoft Lists
Steps to create a list in Microsoft Lists

Then you can see the List got created, here you can see the list icon, color, etc. This Microsoft List looks the same as a SharePoint Online list.

How to create a list in Microsoft Lists
Create a list in Microsoft Lists

This is how we can create a list in Microsoft Lists. Here we can add columns, create views, write formatting rules, etc.

How to Create and Use Microsoft Lists in Microsoft Teams

Now let us see how to create and use Microsoft lists from Microsoft teams.

See also  SharePoint Customization Examples - Customize a SharePoint Online Site

Open Microsoft Teams and then click on the + icon to add as a tab.

Microsoft lists from Microsoft teams
Microsoft lists from Microsoft teams

Then it will open the Add a tab dialog box, From there select Lists app like below:

create a list from microsoft teams
Create a list from Microsoft teams

Then click on the Save button like below:

create a microsoft lists from microsoft teams
create a microsoft lists from microsoft teams

Then the Lists app will be added as a Microsoft Teams tab. Here you can select from the below two options:

  • Create a list: If you want to create a new list.
  • Add an existing list: If you want to add an existing list.

Here, I have selected the Create a list option to create a new list.

create a microsoft list from microsoft teams
Create a Microsoft list from Microsoft teams

This will open the Create a list tab will open and Here you can provide a Name for the list, Description for the list and choose a color and icon like below:

create a list from teams
create a list from teams

Then click on the Create button. Then you can see the list will be created like below. Here you can add a new items to the Microsoft lists, can add columns etc.

create a list from ms teams
Create a list from ms teams

This is how we can create and use Microsoft Lists from Microsoft Teams.

Features of Microsoft Lists

Now, let us check out the features of Microsoft lists.

  • Easily create a list to share business information, add required columns or customize views according to business requirement.
  • Customize view to present the data according to business requirement
  • Can create a list from Excel spreadsheet
  • Allows to create a list from an existing list
  • Provides a lots of template by default to use and create new list
  • Can integrate easily with Microsoft Teams
  • Integrate with Power Platform (PowerApps and Power Automate)

You may like the following SharePoint tutorials:

See also  Create PowerApps Date filter

Microsoft lists are almost similar to SharePoint Online modern lists. Here, we learned about the new Microsoft 365 app Microsoft Lists. We discussed how to create a list in Microsoft Lists and also we discussed how to create and use the Microsoft lists app in Microsoft teams.

>