Others

How to Create Microsoft Lists Rules for Multiple Lines of Text Columns

Jason Miller Oct 15, 2026 870 views

Question details

Users want to trigger email notifications when notes or comments in Multiple Lines of Text columns are modified in Microsoft Lists.

How to Create Microsoft Lists Rules for Multiple Lines of Text Columns

Product: Microsoft Lists
Device & OS: not provided
Scenario: Tracking project updates and needing to notify team members automatically when multi-line text fields like comments or notes are changed.
Observed behavior: Microsoft Lists currently does not support creating rules directly for Multiple Lines of Text columns via the native Rules interface.

Before you start

Ensure you have access to Microsoft Power Automate and the necessary permissions to create flows linked to your Microsoft List or SharePoint site.

Solution 1Recommended

Use Power Automate to Send Notifications for Text Column Changes

Since native Lists rules don't support multi-line text, creating a Power Automate flow is the most effective workaround.

While Microsoft Lists offers a straightforward 'Rules' feature, it intentionally omits support for complex fields like 'Multiple Lines of Text' and 'Attachment' columns. To achieve this functionality without waiting for a product update, you need to use a Power Automate flow that monitors item updates and sends an email when specific changes are detected.

Open Power Automate

Navigate to Power Automate from your Microsoft 365 app launcher and click 'Create' to start a new Automated cloud flow.

Choose the SharePoint Trigger

Select the SharePoint trigger 'When an item or a file is modified'. Enter your Site Address and select the List Name from the dropdown menu.

Retrieve Item Changes

Add a new action called 'Get changes for an item or a file (properties only)'. Pass the Item ID and Trigger Window Start/End tokens to identify exactly which columns were updated.

Add a Condition

Insert a 'Condition' block. Configure it to check if the dynamic content 'Has Column Changed: [Your Multi-line Text Column Name]' is equal to 'true'.

Send an Email Notification

In the 'If yes' branch of your condition, add the 'Send an email (V2)' action. Fill in the recipient, subject, and body, including dynamic content to show the updated notes or comments.

Test Your Flow: Always test your flow by manually modifying a multiline text column in your list to ensure the email triggers correctly.

Solution 2

Submit Feedback for Native Rule Support

Request native support from Microsoft if you require a no-code Lists rule solution.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

If you are frustrated by the limitations and complex workarounds of Microsoft Lists, you can simplify your daily data tracking and spreadsheet management with WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office for your word processing, spreadsheets, and presentation needs.

1. Download and Install: Visit the WPS Official website to download WPS Office Free and install it on your computer or mobile device.
2. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet to create a robust tracking list for your project.
3. Track Project Notes Easily: Set up columns for your project notes and multiline comments, utilizing built-in collaboration features to track changes effortlessly.

Highly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Free and lightweight suite for seamless document management and data tracking.Familiar, tabbed user interface allowing for an easy migration without a learning curve.Easily track project notes and long comments in WPS Spreadsheet without configuring complex automation flows.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select my Multiple Lines of Text column when creating a Microsoft Lists rule?

Microsoft Lists currently restricts the native Rules feature to simple column types like Single Line of Text, Choice, and Date. Complex fields like Multi-line text and Attachment columns are not supported in the no-code interface.

Do I need a premium license to use Power Automate for this workaround?

No, standard Microsoft 365 licenses include basic Power Automate capabilities. These are sufficient for using the SharePoint 'When an item is modified' trigger and sending standard Office 365 emails.

Can I trigger an alert for attachment changes in Microsoft Lists?

Similar to Multiple Lines of Text columns, attachment fields are not supported by default Lists rules. You must also rely on a Power Automate flow to monitor and trigger alerts for changes to attachments.

Is there a no-code alternative to Power Automate for list notifications?

Currently, no direct no-code alternative exists within Microsoft Lists specifically for multiline text columns. You can use the general 'Alert me' settings for the entire list, but this will trigger an email for any item change, rather than targeting a specific column update.

Office Quick Solutions