Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Microsoft Lists: The Evolution of SharePoint Lists

SharePoint Lists has played a pivotal role in building customised solutions on top of SharePoint making SharePoint not just a CRM or DMs but a development platform for developing solutions delivering a wide range of business scenarios. Every SharePoint developer/end-user have used lists in one way or another whether it’s just for creating announcements/tasks or storing complex relational data for an application.

But when it comes to list-based scenarios that include share, track and view list-based information, SharePoint Lists out of the box fall short and require some customisation by developers to fulfil business requirements. In order to fill the gap, Microsoft introduced the launch of a new tool in the Microsoft365 world called Microsoft Lists at the MS Built Conference 2020. According to  Microsoft, Lists “makes it simple to create, share and track data and information,” and will offer features like issue tracking and status reporting from within Teams and SharePoint.

Today, we are going to take a good look at this new and shiny tool of Microsoft and how it compares against the SharePoint Lists.

Microsoft Lists: A one-stop for information tracking

Microsoft Lists is smart and innovative information tracking office 365 app that helps you track information and organise your work. Lists are simple, smart, and flexible, so you can stay on top of what matters most to your team. Track issues, assets, routines, contacts, inventory and more using customisation views and smart rules and alerts to keep everyone in sync. With ready-made templates, you can quickly start lists online, on our new mobile app, and directly from within Microsoft Teams. And because it is part of Microsoft 365, you can rely on enterprise-grade security and compliance.

What about SharePoint Lists?

Microsoft lists is an evolution of the well-known and widely used SharePoint Lists. In-fact it encompasses SharePoint lists while delivering more simplicity and a host of features including a new Lists home page (web), lists in Microsoft Teams and the coming Lists mobile app. Microsoft Lists are even stored in SharePoint sites and can be accessed from the new Lists home page, directly from the SharePoint team site (as shown here), or from within Microsoft Teams. All the existing lists in your SharePoint sites will reap the benefits of Microsoft Lists as well.

Views, Rules, and Sharing Capabilities


Microsoft Lists provides users with four different views to view the information and each one has its benefits depending on the way you want to visualise the data,

Grid view: It is your best choice if you want to list your information to be edited quickly. Think of your product catalogues or asset inventories. It is primarily rows and columns that can be reordered and configured in a way that suits you the best.

Image source: techcommunity.microsoft.com

List View: Those who love their SharePoint List views will take List view as their preferred choice and is best when you just want to view your data without editing capabilities.

Gantt View: As the name suggests, it will display your data in a Gantt view format so think of your project management and resource tracking lists.

Calendar View: If you are maintaining a list of events and want to display it in a calendar view then behold Calendar view is here to render your list in a Calendar format.

Image source: techcommunity.microsoft.com


Rules provide you with the capability of implanting business logic in your lists. Traditionally, business logic in SharePoint Lists can only be implemented by developers via event handlers or workflows but Microsoft Lists makes it as easy as writing a sentence. Once you decide on the outcome, click-fill if/then steps to design your rules.

Image source: techcommunity.microsoft.com


Lists are mostly used as a tool of collaboration which makes sharing a key factor to work with others and do so in a way that is efficient and manageable. Users can easily share the entire list with a defined permission level (edit or read-only) alternatively they can share individual items with an expiration date or require a password before granting access. And once shared, invitees can add comments on the full list or on individual list items.

Image source: techcommunity.microsoft.com

Accessibility options: Web, Mobile and Ms Teams

Microsoft is coming up with three different ways to create and collaborate on lists. Users can start creating lists by launching Microsoft Lists website from the Office 365 App launcher. Microsoft Lists mobile app will enable users to view and update their lists via their mobile devices. Lists are tightly integrated with Ms Teams as well allowing users to collaborate on lists from within their Ms Teams chats and channels. This brings content and conversation side-by-side in one integrated experience. You can either add an existing list to a Teams channel or create a new list directly in Teams and chat on individual list items.

Microsoft Lists will also be integrated with the Power Platform, allowing users to create custom list forms for their lists using Power Apps and defined workflows with Power Automate.

Getting started with Pre-defined templates

Predefined templates are a great way to get something up and running in no time. Microsoft Lists features a list of pre-defined templates to structure information, such as templates for onboarding checklists, issue tracking, meeting events planning, and business trips. These templates come with a base structure, formatting, forms, conditional formatting, and everything you will need to get a quick start on the work that matters to you.

Image source: techcommunity.microsoft.com

Common Use cases

Essentially, Microsoft lists can be used in any scenario which requires maintaining, storing and tracking list-based items. Some common use cases include

  • Tracking company assets including laptops and accessories.
  • Maintaining customer and supplier contacts
  • Tracking office supplies inventory
  • Managing events Calendar
  • New hire onboarding checklist

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables with SQList by AxioWorks, making SharePoint data available to reporting tools like Power BI, Crystal Reports, or SSRS.


Microsoft Lists is a much-awaited upgrade for SharePoint lists with enhancements such as easy to write rules, multiple viewing and accessibility options, and greater sharing capability. Business Users will love the easy to use interface for creating lists and incorporating business logic via rules whereas developers will enjoy the extensibility and integration features for devising solutions. The existing lists running in SharePoint sites will get the flexibility to be used from within Ms Teams or via Lists mobile App and the new lists created in Ms Lists will be available in SharePoint sites as well. We will recommend to check out the predefined lists once Ms Lists is launched as a playground to explore all the features.

Latest articles

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

16 Aug 2023

I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
[read article]

AxioWorks Newsletter July 2023: Unveiling AxioWorks’s latest successes and exciting innovations

27 Jul 2023

Hello Reader, We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
[read article]

AI and Data: The Symbiosis of Interaction and Accuracy

13 Jul 2023

Artificial Intelligence (AI) has rapidly emerged as a revolutionary technology that fundamentally alters the nature of human-machine interactions. […]
[read article]

AxioWorks Newsletter June 2023: SQList v8 Release, Webinars, and New Product Development

30 Jun 2023

Hello Reader, Greetings to all our valued customers and subscribers! We are thrilled to share some exciting updates and developments with you in this […]
[read article]

Safeguarding Secrets with Secure Strings and Environment Variables in the Power Platform

26 Jun 2023

In today’s interconnected digital landscape, safeguarding sensitive information and maintaining robust security measures is of paramount […]
[read article]

Case study: Streamlining Medical Trial Data Analysis in the Pharmaceutical industry

15 Jun 2023

In the ever-evolving landscape of the pharmaceutical industry, conducting medical trials and analysing the resulting data are critical for the […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter