Others

How to Filter Array by Due Date and Status in Power Automate

Steve K Oct 19, 2026 869 views

Question details

The user needs to filter items retrieved from a SharePoint events list based on both a calculated due date and a specific choice column status.

How to Filter Array by Due Date and Choice Status in Power Automate

Product: Power Automate
Device & OS: not provided
Scenario: Filtering a SharePoint events list in Power Automate to send reminder emails only for items due within a specific timeframe and explicitly marked as 'Not started'.
Observed behavior: The flow successfully filters items by the number of days until the due date but currently lacks the condition to exclude items marked as 'In progress' or 'Complete'.

Before you start

Verify the exact internal name of your SharePoint Choice column (e.g., 'Status') and check whether your Power Automate connector returns this column data as an object or as plain text.

Solution 1Recommended

Use an AND Logical Expression in the Filter Array Action

Combine your existing due date calculation with a status check by wrapping both conditions inside an @and() function within your Filter Array action.

Power Automate's Filter Array action allows you to define complex logic using advanced expressions. By utilizing the @and() function, you can ensure that an item is only included if it meets multiple criteria simultaneously—in this case, matching both the required integer value for days due and the exact string 'Not started'.

Access advanced mode in Filter Array

Open your Power Automate flow, locate the existing 'Filter array' action, and click 'Edit in advanced mode' to input a custom expression.

Write the combined AND expression

Enter the expression combining both rules: @and(equals(int(item()?['DueDate_x0020_till_x0020_Today']), variables('DaysDue')), equals(item()?['Status']?['Value'], 'Not started')).

Customize the expression variables

Replace 'Status' with the exact internal name of your SharePoint choice column, and replace variables('DaysDue') with the specific variable or integer value you use to calculate the reminder date.

Save and test your flow

Save your changes and trigger a test run. Verify the output of the Filter Array action to ensure that items marked 'In progress' or 'Complete' are successfully excluded from the final array.

Use an AND Logical Expression in the Filter Array Action

Handling Plain Text Choice Columns: If the SharePoint connector returns the choice column value as plain text rather than a JSON object, your status condition will fail. In this case, modify the second part of the expression to use item()?['Status'] instead of item()?['Status']?['Value'].

Free Microsoft Office alternative

Looking for a Lightweight Office Solution? Try WPS Office

While Power Automate manages your workflows and SharePoint data, you still need a reliable suite to handle the documents, spreadsheets, and reports generated by your automated processes. WPS Office provides a powerful, highly compatible, and free alternative to Microsoft Office.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight application size and incredibly fast startup times.Clean, familiar user interface ensuring seamless migration with zero learning curve.Built-in PDF editing, conversion, and annotation tools.

microsoft office alternative - wps office

Frequently Asked Questions

How do I find the exact internal name of my SharePoint choice column?

Navigate to your SharePoint List Settings, click on the name of your choice column, and look at the URL in your web browser. The string of text immediately following 'Field=' at the very end of the URL is the internal name of your column.

Why does my Filter Array fail with a 'property cannot be evaluated' error?

This error typically occurs if the choice column is completely empty (null) for certain list items, or if you are attempting to append '?['Value']' to a field that is already returning plain text. You can wrap your item calls in a coalesce() function to safely handle null values.

Can I add more than two conditions to a single Filter Array action?

Yes, but the standard @and() function only accepts two arguments at a time. To evaluate three or more conditions, you must nest the functions, for example: @and(condition1, and(condition2, condition3)).

Office Quick Solutions