Others

How to Stop Power Automate Emails When a Microsoft List Item is Closed

Huda Qurayshi Sep 27, 2026 869 views

Question details

The user wants to prevent Power Automate from sending recurring reminder emails once a Microsoft List item's status is changed to Closed.

How to Stop Power Automate Emails After a Microsoft List Item is Closed

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Managing automated task reminders based on Microsoft Lists item statuses.
Observed behavior: Power Automate continues to send daily reminder emails even after the associated task in Microsoft Lists has been marked as Closed.

Before you start

Before modifying your flow, ensure you have edit permissions for the Power Automate workflow and note the exact column name used for your Microsoft Lists item status.

Solution 1Recommended

Add a Filter Query or Condition to Your Flow

Modify your Power Automate workflow to explicitly check the status of the Microsoft List item before sending an email.

To stop emails for closed items, your flow must be instructed to ignore items that have a 'Closed' status. This can be done efficiently using an OData Filter Query or by adding a Condition step.

Locate the Get Items Action

Open your workflow in Power Automate, click Edit, and find the 'Get items' action connected to your Microsoft List.

Apply a Filter Query

Expand the advanced options of the 'Get items' action. In the 'Filter Query' field, enter a formula like Status ne 'Closed' (replace 'Status' with your actual internal column name) to exclude completed tasks.

Use a Condition Step (Alternative)

If you cannot use a filter query, click 'New step' before your 'Send an email' action. Choose 'Condition', set the first value to your Status dynamic content, choose 'is not equal to', and type 'Closed'. Drag your email action into the 'If yes' branch.

Add a Filter Query or Condition to Your Flow

Tip: Using a Filter Query in the 'Get items' action is recommended over a Condition step, as it prevents the flow from retrieving unnecessary data, making your workflow faster and more efficient.

Solution 2

Seek Help in the Power Automate Community Forum

If you are using complex logic or custom columns, the official community forum is the best place to get specific workflow assistance.

Free Microsoft Office alternative

Manage Your Tasks and Spreadsheets with WPS Office

While WPS Office does not directly execute Power Automate workflows, WPS Spreadsheet offers a robust, easy-to-use alternative to Microsoft Excel and Lists for tracking tasks, updating statuses, and managing project data manually or through built-in formulas.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the Software: Run the downloaded setup file and follow the on-screen instructions to complete the installation.
3. Start Tracking Tasks: Open WPS Spreadsheet, import your existing Microsoft Excel data, and use Data Validation to easily manage 'Open' and 'Closed' task statuses.

Fully compatible with Microsoft Excel (.xlsx) formatsBuilt-in data validation and conditional formatting to track task statuses effortlesslyFree and lightweight alternative to heavy Microsoft ecosystem toolsFamiliar, intuitive interface requiring no steep learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate flow keep sending emails for completed Microsoft Lists tasks?

This happens when the flow lacks a specific condition or filter query to exclude items marked as 'Closed'. Without a filter, a scheduled flow will retrieve all items in the list and send an email for every single one, regardless of its current status.

What is the correct OData filter query to exclude closed items in Power Automate?

You can use the query `Status ne 'Closed'` in the 'Get items' action. Ensure you use the internal column name for 'Status' (which might be different from the display name) and ensure 'Closed' matches the exact text of your status option.

Can I use a Condition action instead of a Filter Query?

Yes. You can add a 'Condition' step that checks if the Status dynamic content 'is not equal to' Closed. You then place your 'Send an email' action inside the 'If yes' branch. However, using a Filter Query is generally more efficient for performance.

Office Quick Solutions