Others

Fix Power Automate Excel Date Condition Always Returns False

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs to fix a Power Automate workflow where a condition comparing Excel dates to a date 14 days away consistently fails and returns an ActionBranchingConditionNotSatisfied message.

Product: Microsoft Excel / Power Automate
Device & OS: not provided
Scenario: Creating an automated workflow that involves reading dates from an Excel table and applying conditional logic based on future or past date comparisons.
Observed behavior: The date condition evaluates as false (ActionBranchingConditionNotSatisfied) due to empty cells in the Excel table, dates being read as raw serial numbers, or the comparison using the incorrect addDays direction.

Before you start

Ensure that your Excel data is formatted as a standard Table, as Power Automate requires the 'List rows present in a table' action to correctly map and read the spreadsheet columns.

Solution 1Recommended

Filter Empty Cells and Use ISO 8601 Date Formatting

Prevent condition failures by excluding empty Excel date cells and standardizing the date format to ISO 8601 natively within the Power Automate action.

Power Automate often struggles with Excel dates if it encounters empty cells or reads the date as a serial number. Standardizing the format and filtering out blanks before the condition step resolves most comparison issues.

Format DateTime to ISO 8601

In your Power Automate flow, click on the 'List rows present in a table' action. Expand 'Show advanced options' and set the 'DateTime Format' dropdown to 'ISO 8601'.

Add a Filter Array action

Insert a 'Filter array' action after the Excel list step and before your condition. Set it to filter the values from the Excel table.

Configure the exclusion expression

In the filter condition, use the expression empty(item()?['Date']) is not equal to true. Replace 'Date' with the actual name of your date column.

Update your Condition step

Modify your Condition action to use the output from the 'Filter array' step instead of the raw Excel table output, and compare the dates directly.

Formatting Success: Setting the format to ISO 8601 ensures Power Automate reads the Excel data as a standard date string (e.g., YYYY-MM-DD) instead of an integer serial number.

Solution 2

Correct the addDays Expression for Future or Past Dates

Ensure the date comparison calculates the correct time direction (future or past) using the proper addDays formula.

Free Microsoft Office alternative

Manage Your Spreadsheet Data Seamlessly with WPS Office

While workflow automations like Power Automate require the Microsoft ecosystem, you can create, edit, and format your daily Excel tables highly efficiently using WPS Office. It is a lightweight, highly compatible, and free alternative to Microsoft Office that ensures your data is perfectly structured for any future automation.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly without any conversion.
3. Format as Table: Select your data range, click 'Insert' and choose 'Table' to properly structure your data for future use.

100% compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight application that runs smoothly on older and newer devicesFamiliar user interface requiring zero learning curveFree built-in PDF toolkit and advanced data formatting tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate read my Excel dates as serial numbers?

By default, Excel stores dates as sequential serial numbers for calculation purposes. Unless you explicitly select the ISO 8601 format in the 'List rows present in a table' advanced options, Power Automate will pull this raw serial number instead of a standard calendar date.

What does the ActionBranchingConditionNotSatisfied error mean?

This is not an error in the traditional sense; it is a status message indicating that the logical condition you set in your workflow evaluated to 'false'. The workflow will then proceed down the 'If no' branch.

How do I ignore blank date cells in Power Automate?

You can use a 'Filter array' action immediately after fetching your Excel rows. By configuring it with the expression empty(item()?['YourDateColumnName']) is not equal to true, you ensure that blank cells are discarded before the condition evaluates them.

Office Quick Solutions