Microsoft Lists update explained: what it means for lists

Share
A laptop on an office desk showing the Microsoft Lists interface with a list and columns visible.

Microsoft Lists' update refreshes the list UI, adds new column types and tighter Power Automate/Teams integration, and changes rule and formatting behavior. Decide to enable it by testing against representative lists and flows: most existing lists will keep working, but rendering, column semantics and some connector actions can require changes.

What exactly changed in the Microsoft Lists new update

The update modifies the Lists user experience and adds new column and automation behaviors. Below are the concrete changes and why each one matters.

  • New column types: Adds at least one compound or rich column type (for example a multi-value choice with inline metadata).

Why it matters: stores more structured data in a single column and can change how forms, exports and APIs expose values. Scripts or flows that reference a simple field value may need to handle nested data.

  • Updated list view editor: The view editor UI is reorganized with drag-and-drop column reordering and a visible layout preview.

Why it matters: editing views is faster. Existing custom view settings remain, but re-saving a view under the new editor can update the view metadata.

  • Enhanced formatting and conditional rules rendering: Conditional formatting rules run in a new renderer that can change alignment, color fidelity and nested-rule behavior.

Why it matters: visual rules may look or behave differently where rules overlapped or relied on host-specific CSS; logical expressions themselves usually remain valid but verify visual output.

  • Simplified rules and automation panel: Rules creation and management are consolidated into a single panel offering suggested actions and Power Automate templates.

Why it matters: authors get suggested templates and may be prompted to convert list rules to flows; existing rules generally continue to run but conversion can change trigger timing.

  • Integration points: New triggers or actions appear in the Power Automate connector for Lists and Teams tab behavior is clarified.

Why it matters: flows using older connector actions usually keep working, but new actions require connector updates and possibly additional connector permissions.

For example: say you used a custom JSON column formatter to display badges; the renderer change can require a small JSON tweak to retain exact spacing or color contrast.

How do I know if my tenant or user has the update yet

Start with Microsoft admin signals, then verify in the client for specific users.

  • Where to check:
  • Message Center posts in the Microsoft 365 admin center.
  • The Microsoft 365 Roadmap entry for the update.
  • Tenant-level check (admin):
  1. Sign in to the Microsoft 365 admin center as a global admin or SharePoint admin.
  2. Open Message Center and look for the Lists update message.
  3. If available, open the SharePoint admin center and review 'Settings' for Lists feature toggles.
SharePoint admin center > Settings > Lists settings
Settings path

Message Center entries show the targeted release ring and available dates; absence of a post can mean selective rollout.

  • User-level check (list owner or power user):
  1. Open a Microsoft List in the web client.
  2. Open view options (for example 'All items' > 'Format current view' or 'Rules') and look for a consolidated rules panel or a visual view editor with drag handles and live preview.
  3. Compare the UI while signed in as an admin and as a regular user to detect user-by-user rollout.
  • Quick verification checklist:
  • Confirm Message Center shows the update for your tenant.
  • Open a known list as an admin and as a non-admin user to compare behavior.
  • Use an incognito browser session to rule out cached UI assets.

If you need to confirm for a particular user, ask them to capture a screenshot of the view editor or rules panel for direct comparison.

Will this break my existing lists, views, rules or Power Automate flows

Short answer: most lists and flows will keep working, but check rendering, column semantics and connector usage. Use the checklist below to find likely compatibility issues and back up before broad enablement.

Compatibility risks and where to look:

  • Column semantics: New compound or rich column types change how values are stored and exported. Flows or scripts that reference a column by internal name can break if the column becomes nested.
  • Conditional formatting: The new renderer can alter how overlapping rules apply. Visual differences are likely; logic breakage is less likely unless formatters used deprecated CSS or host assumptions.
  • Views: The new editor can change default view definitions when users re-save views. Custom settings remain but re-saving may rewrite view metadata.
  • Rules vs flows: The UI nudges authors toward Power Automate templates. Existing rules usually continue, but replacing a rule with a flow can introduce different trigger timing and execution details.
  • Power Automate connectors: New actions require connector updates and extra permissions. Validate connections and re-authenticate if flows surface new actions.

Checklist to assess risk for a list:

  1. Identify lists with custom column formatters, JSON, or PowerShell scripts.
  2. List all Power Automate flows and their triggers/actions tied to each list.
  3. Note views that include complex filters, groupings or were re-saved recently.
  4. Export a copy of the list schema and data.

Safe rollback and backup approach:

  • Export data to Excel and save a site/list template when possible.
List > Export to Excel
Export steps
  • Save JSON column formatter and view definitions to a repository or document.
  • Export each Power Automate flow as a package.

Do not rely on clearing browser cache to undo UI changes; use exports and templates for rollback.

If you find compatibility problems, restore the list from exported data or re-import the saved template, and restore flows from the exported packages.

Two IT administrators at a conference table, one pointing at a laptop displaying Microsoft Lists while discussing flow compatibility notes.

How to enable or configure the new features safely

Enable gradually with a pilot and clear rollback steps.

Recommended enablement sequence:

  1. Pick a pilot site or site collection with representative lists (forms, flows, custom formatting).
  2. Add admins and a few power users to the pilot group and confirm they see the update.
  3. Back up pilot lists and flows using the export steps in the previous section.
  4. Enable the update for the pilot (tenant toggle or targeted release assignment if present).
  5. Run a test plan that exercises common scenarios: create/edit items, open forms, run flows, export views, and test mobile access.

Example: enabling the refreshed view editor and validating it

  1. As a tenant admin, confirm the Message Center note that your tenant is targeted or that a toggle exists in the SharePoint admin center.
  2. Ask a pilot list owner to open the list in the browser and edit a view.
  3. Make a minimal change (reorder a column) and save the view.
  4. Verify the view renders correctly for the owner, a regular user, and in the Teams tab.

Keep a saved copy of the original view (copy the view or export its definition) before saving changes created by the new editor.

Verification steps after enabling any new feature:

  • Confirm list permissions remain unchanged.
  • Run the most-used Power Automate flows and inspect run history for failures.
  • Open lists in the SharePoint mobile app and Teams tab to check rendering.

If a test uncovers a problem, restore the list from the exported data and roll back any tenant toggle if available.

Licensing, platform and integration considerations I should check

Check licensing and client platform requirements before wider rollout.

  • Licensing: The core Lists experience is included in most Microsoft 365 business and enterprise plans. Some advanced integration templates or premium Power Automate actions require additional licensing (for example, per-user Power Automate plans). If a new connector action requires premium licensing, flows using that action will fail for users without the license.
  • Platform requirements:
  • Browser: Use the latest supported versions of Edge or Chrome for best rendering.
  • SharePoint: The Lists service depends on SharePoint Online; on-premises SharePoint Server is not affected.
  • Mobile app: Some UI changes appear in web first and later in mobile clients; test mobile separately.
  • Integration notes:
  • Power Automate: Update the Lists connector in flows if you see new actions or Microsoft recommends converting rules to flows. Validate connections and re-authenticate connectors after the update.
  • Teams: Lists added as a Teams tab should continue to work; ensure the Teams client is up to date if the new UI shows differences.
  • API and scripts: If scripts use REST or Microsoft Graph and parse list field types, confirm field metadata hasn't changed. Compound fields present different schema; update scripts to reference field internal names and handle nested values.

If unsure about licensing for a specific automation template, check the flow's details in Power Automate where connector requirements are listed.

Common misunderstandings and quick FAQ for teams and admins

This section clears common confusions and answers short admin and user questions.

Misunderstandings to avoid:

  • "The update rewrites all lists": Not true. The update changes the UI and adds features; existing lists and most flows continue to function. Re-saving or converting views and rules under the new UI can alter metadata.
  • "Everyone gets it at once": Microsoft rolls out in rings; availability can be tenant-level, targeted release, or user-by-user within a tenant.
  • "New features always need new licenses": Often false. Many Lists features are included, but premium Power Automate actions or specific templates may need extra licensing.

Short FAQ

Q: Can I revert the UI if users dislike it?

A: There is no guaranteed per-user client toggle. Reversion depends on Microsoft providing a tenant control or rolling back the rollout. Use backups and templates to restore list behavior if needed.

Q: Where do I report bugs or request early access?

A: Use the Microsoft 365 admin center Message Center for tenant-impacting issues and the in-app feedback option for UI bugs. For early access, use targeted release settings or contact Microsoft support.

Q: Will Power Automate flows need re-authentication?

A: Sometimes. If connector actions change or need additional permissions, flows may prompt for re-authentication. Include connector checks in your test plan.

Q: Are mobile users affected differently?

A: Mobile clients may receive UI updates later than web. Test mobile scenarios and Teams tabs separately.

Conclusion

Start with a small pilot and backups: export lists and flows, run the new view and rules editor through representative use cases, and validate Power Automate runs. If the pilot passes, expand the rollout; if you see compatibility issues, restore from the saved exports and report problems through Message Center while you work with Microsoft support.

Frequently Asked Questions

How do I quickly back up a list before enabling the update?

Export to Excel from the list, save any column JSON formatters and view definitions, and export related flows from Power Automate as packages.

Will my existing Power Automate flows stop working immediately after the update?

Most flows will continue to run. Flows that depend on changed field schemas or require new connector actions may fail and need updating; include flow validation in your pilot tests.

Who should I put in the pilot group?

Choose one or two site owners, a couple of power users who maintain flows and formatting, and a few regular users who represent common usage patterns (mobile, Teams access).