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.ĪxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BI, Crystal Reports, or SSRS. 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 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. 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.ĭefine Data-driven Rules to set alerts and notifications 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. 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. Reuse and distribute custom lists easily via Custom Templates 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: The modern create list experience includes the choice to import an Excel spreadsheet and data into a newly generated MS List. 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.

Transform an Excel spreadsheet into MS ListĮxcel 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. 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.

Users can still use this lightweight app to create lists from various templates, including Excel files or “a blank slate,” the message continues. To access this online-only app, users can sign in at. 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. 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. 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. Lightweight Standalone MS Lists app that requires no O365 subscription In this blog, I will share 5 of the most exciting MS List features which help users achieve greater productivity and collaborate efficiently.

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. 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. By Danish Ali Detho | O365 & Power Platform Solution Architect

Microsoft lists reminders