Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET
Microsoft Teams|Office|Office 365|SharePoint Online

Using Microsoft Lists in Teams Channels

Teams, Tabs, and Lists

Office 365 notification MC220295 posted on 13 Aug 2020 (Microsoft 365 roadmap item 64162) announces the arrival of the Lists app for Teams. This app allows access to Microsoft Lists, the new iteration of the well-known SharePoint lists, with the notable restriction that personal lists (stored in OneDrive for Business) are not supported. The lists accessible through the app are those stored in SharePoint team sites.

The Lists application in SharePoint is still being deployed to Office 365 tenants. Roll-out should be complete in early September. Lists must be available in the tenant before Microsoft can deploy the Teams app, which MC220295 says should be available worldwide by mid-October.

Available to All Teams Users

By default, the Lists app is available to all Teams users. The app allows users to create a channel tab by creating a new list or setup a tab pointing to an existing list within the team site. If you don’t want users to use the Lists app, you can deploy a custom app permission policy to block access to the app.

Adding the Lists App to a Channel

Microsoft preinstalls the Lists app to all Teams, so adding it to a channel tab is simple. Create a new tab and select Lists from the set of available apps (Figure 1).

Sponsored Content

Say Goodbye to Traditional PC Lifecycle Management

Traditional IT tools, including Microsoft SCCM, Ghost Solution Suite, and KACE, often require considerable custom configurations by T3 technicians (an expensive and often elusive IT resource) to enable management of a hybrid onsite + remote workforce. In many cases, even with the best resources, organizations are finding that these on-premise tools simply cannot support remote endpoints consistently and reliably due to infrastructure limitations.

Image 1 Expand
Figure 1: Selecting the Lists app for Teams to add to a channel (image credit: Tony Redmond)

After selecting the Lists app, you must save the app to make Lists available in the channel. Once saved, you can go ahead and create a new list or associate an existing list with the tab.

Creating Lists Tab from an Existing List

New lists can be created from scratch, from an Excel spreadsheet, or by using one of the eight templates provided by Microsoft. The process of creating and populating a new list is the same as through the SharePoint Online or OneDrive for Business browser interfaces. Figure 2 shows the dialog used to add an existing list to a channel tab.

Image 2 Expand
Figure 2: Add an existing list to a Teams channel (image credit: Tony Redmond)

To add an existing list with a URL, open SharePoint Online and navigate to the host site to open the list. Copy the URL from the browser bar, which will be something like shown below:

If you make a mistake and add the wrong list, simply delete the channel tab, and start again. Removing the tab won’t affect the underlying list. If you want to delete a list, you must do this in SharePoint Online or the browser Lists app.

Working with Lists in Teams

The appearance and operation of the Lists app in Teams is like its browser counterparts (Figure 3).

Image 3 Expand
Figure 3: Viewing list data in Teams (image credit: Tony Redmond)

After opening a list item, you can edit it, add columns (everyone in a team has equal access to the list, including its design), create a link to the list, or launch a conversation about the item (Figure 4).

Image 4 Expand
Figure 4: Starting a channel conversation about a list item (image credit: Tony Redmond)

Starting a conversation creates a new topic in the channel (without a subject, regretfully) with an embedded link to the list item. Only users who are allowed access to the Lists app can open the item. Other users can see the conversation and follow replies, but they aren’t allowed to use the link to access the item.

Mobile Lists

The Teams Mobile client supports access to lists via channel tabs (Figure 5). You can view, add, and edit list items, but you can’t create a list or remove a list from a channel using the mobile client, nor can you start a conversation about a list item as you can in the desktop or browser clients. I also couldn’t find a way to delete list items. None of these restrictions matter very much because the use case for mobile access is predominantly focused on viewing list information.

Image 5 Expand
Figure 5: Lists in Teams for iOS

Useful Lists

Although I am not as enthusiastically positive about the collaboration possibilities created by the Lists app in Teams, Lists are a good way to organize and manage tabular data. Lists are more approachable in many ways than Excel worksheets and they’re not as task-oriented as Planner is. Lists is the Swiss Army Knife of tabular organization in Office 365; people will find lots of ways to use the Teams app, which is a nice state to be in.


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (0)

Leave a Reply

Tony Redmond has written thousands of articles about Microsoft technology since 1996. He covers Office 365 and associated technologies for and is also the lead author for the Office 365 for IT Pros eBook, updated monthly to keep pace with change in the cloud.