This chapter covers Microsoft Lists, a Microsoft 365 app for tracking work items with structured data, rules, and automation. For the MS-900 exam, understanding Lists is part of Objective 2.4, which focuses on Microsoft 365 productivity tools. While Lists is not a major topic on the exam (typically 1-2 questions), it often appears in scenarios comparing it to SharePoint lists, Excel, or Planner. This chapter provides a thorough understanding of Lists' capabilities, limitations, and integration points to help you answer these questions correctly.
Jump to a section
Imagine a traditional filing cabinet where each drawer holds folders, and each folder contains documents. This cabinet is static — you must manually insert, remove, or update each document, and only one person can access a folder at a time. Microsoft Lists transforms this cabinet into a digital, dynamic system. Each 'list' is like a drawer equipped with a built-in database engine. Instead of paper documents, each 'item' is a structured record with predefined fields (columns) like 'Task Name', 'Assigned To', 'Due Date', and 'Status'. When someone creates or updates an item, the list automatically logs the change, sends notifications to relevant team members (like a secretary alerting you when a new document arrives), and enforces rules such as 'Due Date cannot be in the past' (like a checklist that prevents misfiling). The list can be shared with many people simultaneously, each seeing the same up-to-date information. Furthermore, the list can be connected to other apps — for example, a Power Automate flow can watch for a status change to 'Complete' and then automatically move the item to an archive list, similar to having a robot that reorganizes files based on content. This eliminates the need for manual copying, emailing spreadsheets, and version conflicts.
What is Microsoft Lists?
Microsoft Lists is a Microsoft 365 application that allows users to create, manage, and share structured lists of information. It is essentially a user-friendly interface on top of SharePoint lists, providing a modern, responsive experience across web, mobile, and within Microsoft Teams. Lists enable teams to track issues, assets, contacts, inventory, and more without needing to build a full SharePoint site.
Why Microsoft Lists Exists
Before Lists, users often relied on Excel spreadsheets for tracking, which led to version control issues, lack of real-time collaboration, and difficulty in enforcing data integrity. SharePoint lists existed but required SharePoint knowledge to create and customize. Lists bridges this gap by offering a simple, app-like experience that non-technical users can adopt quickly, while still leveraging SharePoint's robust backend.
How Microsoft Lists Works Internally
Every Microsoft List is actually a SharePoint list stored in a SharePoint site (usually the default 'Microsoft Lists' site at https://<tenant>.sharepoint.com/sites/MicrosoftLists). When you create a list via the Lists app, it creates a new list in that site. The list has a schema defined by columns, each with a specific data type (text, number, choice, date/time, person, lookup, etc.). Items are rows in the list. Behind the scenes, Lists uses SharePoint's REST API and CSOM (Client Side Object Model) to perform CRUD operations. Permissions are inherited from the SharePoint site, but can be broken to provide unique permissions per list or item.
Key Components and Defaults
Templates: Lists provides several starting templates: Issue tracker, Employee onboarding, Event itinerary, Work progress tracker, etc. Each comes with pre-defined columns and formatting.
Columns: Default columns include Title (single line of text, required), Created (date/time, automatically set), Created By (person/group), Modified (date/time), Modified By. Additional columns can be added with various types.
Views: Lists support personal and public views. Default view is 'All Items'. You can create views to filter, sort, and group items.
Formatting: Column formatting and view formatting can be applied using JSON to change colors, icons, and conditional formatting.
Rules: Lists include 'Rules' (formerly known as 'Automate' > 'Create a rule') that trigger actions when an item is created or changed. Rules can send email notifications, assign tasks, or post to a Teams channel. Rules are powered by Power Automate but are simplified for users.
Versioning: By default, versioning is enabled for list items, keeping a history of changes (limited to 500 versions).
Sharing: Lists can be shared with individuals or groups. Sharing a list grants access to the underlying SharePoint site if the user doesn't already have access.
Configuration and Verification
To create a list: 1. Go to the Lists app (https://lists.microsoft.com or via Teams). 2. Click 'New list' and choose a template or blank list. 3. Name the list and set permissions (private or public). 4. Add columns as needed. 5. Add items manually or import from Excel.
To verify list properties, you can view the list in SharePoint to see site settings, version history, and advanced permissions. There is no PowerShell command specific to Lists, but SharePoint Online PowerShell can be used:
Connect-SPOService -Url https://<tenant>-admin.sharepoint.com
Get-SPOList -Site https://<tenant>.sharepoint.com/sites/MicrosoftListsInteraction with Related Technologies
SharePoint: Lists are stored in SharePoint. Advanced features like content types, workflow, and site columns are accessible via SharePoint but not from the Lists UI.
Microsoft Teams: Lists can be added as tabs in Teams channels. Users can interact with the list without leaving Teams.
Power Platform: Lists can be used as data sources for Power Apps and Power Automate. Power Automate flows can be triggered by list events.
Excel: Lists can be exported to Excel and imported from Excel. However, Lists is not a replacement for Excel for complex calculations.
Planner: Both are task tracking tools, but Planner is Kanban-focused with buckets and assignments, while Lists is more structured and customizable.
Limitations
Maximum of 30 million items per list (SharePoint limit).
No built-in Gantt chart or timeline view (use Project for that).
No native dependency tracking between items (use Project or add-ons).
Rules are limited to simple conditions; complex automation requires Power Automate.
No offline editing on mobile (requires internet).
Exam Relevance
MS-900 tests understanding of Lists as a tool for work tracking within Microsoft 365. Key points: Lists is for structured data tracking, it integrates with Teams and Power Platform, it is not a replacement for Planner or Project. Be aware that Lists uses SharePoint as its backend, so sharing a list grants SharePoint site access.
Create a new list from template
Navigate to the Lists app (lists.microsoft.com) and click 'New list'. Choose a template such as 'Issue tracker' or 'Work progress tracker'. Each template includes pre-defined columns like 'Title', 'Assigned To', 'Status', 'Priority'. The list is created in the default Microsoft Lists site. You can also create a blank list and define columns manually. For exam: know that templates exist and that lists are stored in SharePoint.
Add and configure columns
After creating the list, add columns by clicking 'Add column'. Choose from data types: Single line of text, Multiple lines of text, Number, Choice, Date and Time, Person or Group, Yes/No, Hyperlink, Picture, Currency, Lookup (from another list). For each column, you can set required, default value, and validation (e.g., number > 0). Column formatting using JSON allows conditional styling. Exam tip: remember that Lookup columns can reference another list in the same site.
Add items manually or import
Click 'New' to add an item, filling in the columns. Alternatively, import from Excel by clicking 'Import' and uploading a .csv or .xlsx file. The import wizard maps columns automatically. Note that importing from Excel can create duplicate items if not careful. For exam: know that import is supported, but real-time sync with Excel is not — it's a one-time import.
Create and apply views
Views allow you to display items in different ways. Click 'All Items' dropdown and 'Create new view'. Choose a format: List (default), Calendar (requires a date column), Gallery (visual cards). Configure filters, sort order, grouping, and columns to show. Personal views are only visible to you; public views are visible to everyone with access. Exam: understand that Calendar view requires at least one date column.
Set up rules for automation
Rules are simple if-this-then-that automations. Click 'Automate' > 'Create a rule'. Choose a trigger: 'When an item is created' or 'When an item is changed'. Then set conditions (e.g., Status equals 'Completed') and actions: send email, assign a task, post to Teams. Rules are limited; for complex logic, use Power Automate. Exam: know that rules exist and are simplified Power Automate flows.
Share the list with others
Click 'Share' and enter names or email addresses. You can set permission level: Can view, Can edit, or Full control. Sharing the list also grants access to the underlying SharePoint site, which may expose other content. For exam: understand that sharing a list shares the site, and that external sharing requires tenant settings.
Scenario 1: IT Help Desk Issue Tracking
A mid-sized company uses Microsoft Lists to track help desk tickets. The list includes columns: Ticket ID (auto-generated), Requester (person), Category (choice: Hardware, Software, Network), Priority (High/Medium/Low), Status (New, In Progress, Resolved, Closed), Assigned To (person), Description (multiple lines). The IT team uses a Calendar view to see due dates. Rules are configured: when status changes to 'Resolved', an email is sent to the requester. Power Automate flow escalates tickets that are 'In Progress' for more than 3 days. This replaced an Excel spreadsheet that had version conflicts and no automation. Common issues: users accidentally share the list with external parties, exposing the site; large lists (>5000 items) require indexed columns for filtering. Performance tip: create views with filters to avoid threshold limits.
Scenario 2: Employee Onboarding Tracking
HR uses the 'Employee onboarding' template to track new hires. Columns: Employee Name, Start Date, Department, Buddy (person), Checklist items (multiple choice). The list is embedded as a Teams tab so the HR team can update status without leaving Teams. A rule sends a welcome email when a new item is created. Power Automate creates a Planner plan for each new hire. This centralized tracking replaced a binder of paper forms. Challenge: ensuring data consistency across multiple HR staff; solution: use choice columns with validation. Exam tip: this scenario illustrates integration with Teams and Power Automate.
Scenario 3: Asset Inventory Management
Facilities department tracks office equipment: laptops, monitors, chairs. Columns: Asset Tag (text), Type (choice), Location (choice), Assigned To (person), Purchase Date, Warranty Expiration. A Calendar view shows warranty expirations. Rules send reminders 30 days before warranty ends. This replaced a shared Excel file that had data entry errors. Common pitfall: users delete items instead of archiving; solution: use a 'Status' column with 'Active' and 'Retired' values, and filter views to hide retired items. For exam: note that Lists is not an inventory management system but works for simple tracking.
MS-900 Objective 2.4: Describe productivity solutions in Microsoft 365
This objective includes understanding how Lists fits into the suite of productivity tools. The exam focuses on what Lists is used for, its relationship to SharePoint, and its integration with Teams and Power Platform. Common questions ask you to differentiate Lists from Excel, Planner, and Project.
Common Wrong Answers
'Lists is a replacement for Excel' — Wrong. Lists is for structured data tracking with columns and rules, not for complex calculations or pivot tables. Excel is still the tool for data analysis.
'Lists is the same as SharePoint lists' — Wrong. Lists is a user-friendly interface on top of SharePoint lists, but it does not expose all SharePoint features like content types or workflow.
'Lists can be used for project management with dependencies' — Wrong. Lists does not support task dependencies or Gantt charts; use Microsoft Project or Planner for that.
'Lists can sync with Excel in real-time' — Wrong. You can import/export but not sync. Changes in Excel are not reflected in Lists automatically.
Specific Numbers and Terms
Lists can hold up to 30 million items (SharePoint list limit).
Default versioning keeps 500 versions.
Templates: Issue tracker, Employee onboarding, Event itinerary, Work progress tracker.
Column types: Single line of text, Choice, Person or Group, Lookup, etc.
Rules: triggers on create or change; actions: email, task, Teams post.
Edge Cases
When sharing a list, you also share the underlying SharePoint site. This can expose other lists or pages if the site is not locked down.
If a list exceeds 5000 items, you must create indexed columns to avoid threshold errors.
Lookup columns can only reference lists in the same SharePoint site.
How to Eliminate Wrong Answers
Understand the core purpose: Lists is for structured data tracking with simple automation. If a question mentions complex calculations, dependencies, or real-time sync, eliminate Lists. If it mentions Kanban boards, think Planner. If it mentions timelines or resource management, think Project. Remember that Lists is built on SharePoint, so any advanced SharePoint feature (like content types) is not available from the Lists UI.
Microsoft Lists is a structured data tracking app built on SharePoint lists.
Lists can be created from templates or from scratch with custom columns.
Lists support views (List, Calendar, Gallery) and simple rules for automation.
Lists integrate with Teams (as a tab) and Power Platform (Power Automate, Power Apps).
Lists is not a replacement for Excel (calculations) or Planner (Kanban) or Project (dependencies).
Sharing a list also shares the underlying SharePoint site; be cautious with permissions.
Lists can hold up to 30 million items, but performance thresholds apply at 5000 items.
Default versioning keeps 500 versions per item.
These come up on the exam all the time. Here's how to tell them apart.
Microsoft Lists
Structured data with custom columns and data types
Supports views like List, Calendar, Gallery
Rules for simple automation (email, task, Teams)
Integrates with Power Automate for complex flows
Maximum 30 million items
Microsoft Planner
Kanban boards with buckets and cards
Only Board and Chart views
Built-in progress tracking and assignments
Integrates with Power Automate but limited triggers
Maximum 1,000 tasks per plan
Microsoft Lists
Structured rows and columns with enforced data types
Real-time collaboration with version history
Rules and automation without macros
Can be used as a data source for Power Apps
No complex formulas or pivot tables
Excel (in Microsoft 365)
Free-form cells with any data
Real-time co-authoring with AutoSave
Macros and VBA for automation
Cannot be used directly as a data source for Power Apps
Supports complex formulas, charts, and pivot tables
Mistake
Microsoft Lists is a standalone app with its own database.
Correct
Lists uses SharePoint lists as its backend. All data is stored in a SharePoint site, not a separate database.
Mistake
You can use Lists offline on mobile devices.
Correct
Lists requires an internet connection. There is no offline mode for Lists, unlike Excel or OneDrive files.
Mistake
Lists can replace Microsoft Planner for task management.
Correct
Lists is for structured data tracking with custom columns, while Planner is for Kanban-style task management with buckets and assignments. They serve different purposes.
Mistake
Sharing a list only shares that list, not the site.
Correct
Sharing a list also grants access to the SharePoint site, potentially exposing other content. Site owners should manage permissions carefully.
Mistake
Lists can be used for project management with Gantt charts.
Correct
Lists does not have Gantt chart or timeline views. For project management with dependencies and timelines, use Microsoft Project.
Reveal each answer, then mark whether you got it right. Score 60%+ to unlock the next chapter.
Microsoft Lists is used for tracking and organizing structured information such as issues, assets, contacts, and inventory. It provides a user-friendly interface with custom columns, views, and simple automation rules, making it easy for teams to collaborate without needing SharePoint expertise.
Microsoft Lists is a modern, simplified interface on top of SharePoint lists. It offers a more intuitive experience with templates, mobile app, and Teams integration, but it does not expose all SharePoint features like content types, site columns, or advanced permissions. Behind the scenes, every List is a SharePoint list stored in a SharePoint site.
No. Lists is designed for structured data with enforced data types and relationships, while Excel is a spreadsheet application for calculations, analysis, and free-form data. Lists is better for collaborative tracking with rules, while Excel is better for complex formulas, pivot tables, and charts.
No. Microsoft Lists requires an internet connection. There is no offline mode. However, you can export a list to Excel for offline viewing, but changes made offline cannot be synced back automatically.
You can share a list by clicking 'Share' and entering the external user's email. However, external sharing must be enabled at the tenant level. Also, sharing a list grants the external user access to the underlying SharePoint site, which may expose other content. Use caution and consider sharing only the list item or using a secure external sharing link.
Key limitations: no offline mode, no Gantt charts, no task dependencies, no real-time sync with Excel, maximum 30 million items per list, and performance issues beyond 5000 items without indexing. Also, complex automation requires Power Automate, not just rules.
Yes. You can add a Microsoft List as a tab in a Teams channel. This allows team members to interact with the list without leaving Teams. The integration is seamless and supports all List features including views and rules.
You've just covered Microsoft Lists for Work Tracking — now see how well it sticks with free MS-900 practice questions. Full explanations included, no account needed.
Done with this chapter?