Difference between revisions of "Microsoft Lists"

Latest revision as of 16:10, 5 June 2026

Create, collaborate, and present data in a centralized location within your Team or Sharepoint site that is easy to sort and edit.

About Lists

Microsoft Lists allows you to create, collaborate on, and present data in a centralized location within your Microsoft Team or SharePoint site. It is designed to be easy to sort, edit, and view in different formats. You can create a form within Microsoft Lists to easily collect list data.

Key Features

Team Integration: Works across all Microsoft Teams channel types (standard, private, and shared).

SharePoint Integration: Can be embedded into SharePoint site pages as either a read-only report or a collaborative shared repository.

Data Collection: You can build forms directly within Microsoft Lists to easily collect and populate data.

List Training

Microsoft Lists training

Limitations

No Direct Move Function: You cannot directly move a list's entire structure (including its columns, custom views, and settings) to a new SharePoint site or Team once it is created. While you can export the raw data to Excel or a .csv file and copy it over, you will lose your custom formatting and column configurations.

Before you start, always create your list in its final destination.

Rule Constraints: Each individual list is strictly capped at a maximum of 15 automated rules.

Other considerations:

List data library limits
15 rule limit in each list Create a List rule

Version Control & Permissions

Manage background settings keeps your list secure and track changes over time.

Version History Microsoft Lists automatically tracks changes by default. Every time a row is edited, a new version is saved.
To View or Restore:Click the three dots (...) next to any list item and select Version History. You can see who made changes, what was altered, and click Restore to revert to an older version.
Access Permissions You can control who views or edits your data to prevent accidental deletions.
Inherited Access: By default, lists inherit permissions from their parent Microsoft Team or SharePoint site (e.g., Team Members can edit; Guests can only view).
Custom Access: To restrict data, go to Settings (Gear Icon) > List Settings > Permissions for this list. Select Stop Inheriting Permissions to assign unique roles (Full Control, Edit, or Read-Only) to specific people without altering their access to the rest of the Team.
Item-Level Control: For sensitive workflows, advanced settings allow you to configure the list so users can only read or edit items they personally created.

---

Microsoft List or an Alternative?

Choosing the Right Tool
Application	Ideal For	Advantages
Microsoft Lists	Structured, long-term data tracking and internal team repositories.	Robust columns, customizable views, and automated rules.
Microsoft Loop	Easy-to use, easily track usage changes and permissions.	Loop Components update instantly across Teams, Outlook, and Word.
Microsoft Forms	Surveys, quizzes, and feedback gathering.	Easily collects data from audience and can be anonymous.
Microsoft Excel	Heavy data analysis, large data sets, modeling, and complex formulas.	Ultimate data flexibility with no structural move limits.
Microsoft Planner / Project	Complex project management and resource allocation.	Built-in Kanban boards, timelines, and Gantt charts.

@@ Line 8: / Line 8: @@
 </div>
-===What Are Lists===
+===About Lists===
 Microsoft Lists allows you to create, collaborate on, and present data in a centralized location within your Microsoft Team or SharePoint site. It is designed to be easy to sort, edit, and view in different formats. You can create a [https://helpwiki.evergreen.edu/wiki/index.php/Microsoft_Forms form] within Microsoft Lists to easily collect list data.
 ===Key Features===
 '''Team Integration:''' Works across all Microsoft Teams channel types (standard, private, and shared).
 '''SharePoint Integration:''' Can be embedded into SharePoint site pages as either a read-only report or a collaborative shared repository.
 '''Data Collection:''' You can build forms directly within Microsoft Lists to easily collect and populate data.
@@ Line 20: / Line 22: @@
 ===Limitations===
-'''No Direct Move Function:'''You cannot directly move a list's entire structure (including its columns, custom views, and settings) to a new SharePoint site or Team once it is created. While you can export the raw data to Excel or a .csv file and copy it over, you will lose your custom formatting and column configurations. ***Always create your list in its final destination.
+'''No Direct Move Function:''' You cannot directly move a list's entire structure (including its columns, custom views, and settings) to a new SharePoint site or Team once it is created. While you can export the raw data to Excel or a .csv file and copy it over, you will lose your custom formatting and column configurations.
+{{WarningBox|content=
+Before you start, always create your list in its final destination.
+}}
 '''Rule Constraints:''' Each individual list is strictly capped at a maximum of 15 automated rules.
@@ Line 27: / Line 34: @@
 *15 rule limit in each list [https://support.microsoft.com/en-us/office/create-a-rule-to-automate-a-list-or-library-151ea008-7fa6-409b-b0bd-b04a3b3cacd5 Create a List rule]
-===When to Use Lists or Alternatives===
+===Version Control & Permissions===
+Manage background settings keeps your list secure and track changes over time.
-'''Microsoft Excel'''
+* '''Version History''' Microsoft Lists automatically tracks changes by default. Every time a row is edited, a new version is saved.
-*'''When to use:''' When your primary goal is heavy data analysis, complex mathematical formulas, financial modeling, or when you need the flexibility to frequently restructure, move, and copy data sets across different environments.
+* '''To View or Restore:'''Click the '''three dots (...)''' next to any list item and select '''Version History'''. You can see who made changes, what was altered, and click '''Restore''' to revert to an older version.
-*'''Why:''' Excel data can be moved and saved anywhere instantly, bypassing the strict "no-move" structural limits of Microsoft Lists.
+* '''Access Permissions''' You can control who views or edits your data to prevent accidental deletions.
+* '''Inherited Access:''' By default, lists inherit permissions from their parent Microsoft Team or SharePoint site (e.g., Team Members can edit; Guests can only view).
-'''Microsoft Loop'''
+* '''Custom Access:''' To restrict data, go to '''Settings (Gear Icon) > List Settings > Permissions for this list'''. Select '''Stop Inheriting Permissions''' to assign unique roles (Full Control, Edit, or Read-Only) to specific people without altering their access to the rest of the Team.
-*'''When to use:'''Use Loop when you have simplified data-tracking needs that don't require complex features and customization.
+* '''Item-Level Control:''' For sensitive workflows, advanced settings allow you to configure the list so users can only read or edit items they personally created.
-*'''Why:'''You can turn any part of a Loop page (like a table or a task list) into a  component can be copied and pasted directly into a Microsoft Teams chat, an Outlook email, or a Word document that automatically updates everywhere.
-'''Microsoft Planner or Project'''
+---
-*'''When to use:''' When you are managing complex, multi-tiered projects with dependencies, timelines, and resource allocation.
-*'''Why:''' Lists can track basic tasks, but dedicated project management tools offer built-in Kanban boards, Gantt charts, and workload balancing that Lists cannot easily replicate.
+===Microsoft List or an Alternative?===
+{| class="wikitable" style="margin:auto"
+|+ Choosing the Right Tool
+|-
+! Application !! Ideal For !! Advantages
+|-
+| Microsoft Lists || Structured, long-term data tracking and internal team repositories. || Robust columns, customizable views, and automated rules.
+|-
+| Microsoft Loop || Easy-to use, easily track usage changes and permissions. || Loop Components update instantly across Teams, Outlook, and Word.
+|-
+| Microsoft Forms || Surveys, quizzes, and feedback gathering.
+ || Easily collects data from audience and can be anonymous.
+|-
+| Microsoft Excel || Heavy data analysis, large data sets, modeling, and complex formulas. || Ultimate data flexibility with no structural move limits.
+|-
+| Microsoft Planner / Project || Complex project management and resource allocation.
+ || Built-in Kanban boards, timelines, and Gantt charts.
+|}
   <!-- end col-md-8 -->