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.

Five most awesome features in MS Lists

by Danish Ali Detho | O365 & Power Platform Solution Architect

Microsoft Lists previously known as SharePoint Lists have been widely used for maintaining and storing data in SharePoint and its usage has grown even more ever since it has been integrated into MS Teams. Microsoft has recently introduced some exciting new features in MS Ignite which makes MS Lists a must-use tool for storing and maintaining information for business users and it’s not just limited to O365 as well. In this blog, I will share 5 of the most exciting MS List features which help users achieve greater productivity and collaborate efficiently.

Lightweight Standalone MS Lists app that requires no O365 subscription

Microsoft launched a standalone MS Lists App earlier last year in preview which was available as part of an Office 365/Microsoft 365 subscription which means it was available only to users with a Valid O365 subscription. In order to make it more accessible to a wider audience of users, Microsoft has recently launched a new lightweight version of MS List App which doesn’t require a Microsoft 365 subscription. It is designed for small business and individual use in conjunction with your Microsoft account (MSA) Which means Users without any MS O365 license can still use MS Lists App to create and manage lists. To access this online-only app, users can sign in at lists.live.com. Users can still use this lightweight app to create lists from various templates, including Excel files or “a blank slate,” the message continues. And users can “visualize and interact with data in different ways,” such as by showing information in a gallery or tracking work in a calendar using the new Lists app.

Transform an Excel spreadsheet into MS List

Excel has been one of the most widely used tool for storing and maintaining tabular data by business users but one of the pain point was sharing data with other colleagues while keeping it centralized. However, with the emergence of MS Lists the data in excel sheets can be centralized and Microsoft has even made it simpler to create a list out of excel sheets. The modern create list experience includes the choice to import an Excel spreadsheet and data into a newly generated MS List. Table headings in the excel sheet will be converted into list columns and it provides users with the option to use the following list column types:

  • Choice
  • Currency
  • Date and time
  • Multiple lines of text
  • Number
  • Single line of text
  • Title


Reuse and distribute custom  lists easily via Custom Templates

MS Lists comes with a large set of list templates which are designed to make it easier for business users to start creating lists for tracking and maintaining data for commonly used scenarios including events, issues, and travel requests. This gives users a good starting point but they will be making customizations to those lists and eventually would like to use their lists as templates in other departments as well. Now, they can create and deploy custom templates from their lists which can then be used by other users to facilitate the generation of similar lists.

Define Data-driven Rules to set alerts and notifications

Rules provide users the capability to set reminders and send notifications by defining data-change-driven conditions based on changes to list information within Microsoft Teams. Rules can be set by users with edit permissions on the list by selecting the Automate menu and then clicking “Create a rule” in the list command bar near the top of the page. Rules are simple to implement and an effective way of creating alerts with your lists and data without having to use a more advanced tool like Power Automate.

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

Collaborate with Teammates using Comments and @mentions

In Ignite 2021, Microsoft introduced a new feature in MS Lists for improving team collaboration by providing users the ability to add comments to individual list items, including the ability to @mention someone, to collaborate and share insights within Microsoft Teams. It will allow users to passively communicate and share information with a colleague, and that colleague receives a notification bringing them right to the list item within the context of your comment.


MS Lists is packed with some great features which makes it a great tool for maintaining list-based information and thanks to the launch of the standalone Lists app it is now not only limited to just O365 users. Its presence in O365 and seamless integration with MS Teams make it an ideal tool for collaboration in the Microsoft ecosystem. New features such as generating lists from excel and using custom templates to generate lists improve its adaptability and usability even more. It is safe to say that MS Lists is not just limited to SharePoint anymore and it is slowly becoming a highly effective information management tool on its own.

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




Latest articles

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

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]

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