Solution
The flow compared the UTC date with the opening date in mainland Spain. During the first hour of opening day, it was still the previous day in UTC, so applications processed then were rejected.
What happened?
Cloud services commonly use Coordinated Universal Time (UTC). Microsoft documents that Power Automate uses UTC by default, and utcNow() returns the current UTC time. Mainland Spain is one hour ahead of UTC in winter and two in summer.
The flow used utcNow() at the point of evaluating the rule and compared only the date. In this case it processed submissions as soon as they arrived.
Applications opened on 4 March. The rule accepted a request if its UTC processing date was on or after 2026-03-04.
A request sent and processed at 00:20 on 4 March in mainland Spain was 23:20 on 3 March in UTC. The flow saw 2026-03-03 and rejected it.
At 01:00 in mainland Spain, it was 00:00 UTC on 4 March. The dates now matched and the flow accepted the applications.
Testing took place during business hours, when both dates matched.
In summer the two-hour difference would extend the fault until 02:00. It is easy to miss in tests because it occurs only when the local and UTC dates differ, just when people may be trying to apply first.
Technical explanation
The flow condition
As a Power Automate expression, the original comparison was equivalent to:
greaterOrEquals(
formatDateTime(utcNow(), 'yyyy-MM-dd'),
'2026-03-04'
)
Use the actual submission time and convert it to the time zone in which applications open. Here the previous step Submission_time_UTC contains the submission timestamp in UTC:
greaterOrEquals(
formatDateTime(
convertTimeZone(outputs('Submission_time_UTC'), 'UTC', 'Romance Standard Time'),
'yyyy-MM-dd'
),
'2026-03-04'
)
Romance Standard Time is the Windows time zone used for mainland Spain, Brussels, Copenhagen and Paris. It accounts for daylight saving time.
How could it be fixed and prevented?
To fix it , keep the actual submission time, convert it to the application’s time zone before comparing dates, and review rejected applications in order of arrival.
To prevent it from recurring:
Convert to local time for local date rules. Store the timestamp in UTC and use convertTimeZone() or the Convert time zone action to determine the local date.
Test around midnight. Try submissions just before and after midnight as well as during business hours.
Check run history. Power Automate records each run’s data. A trailing Z as in 2026-03-03T23:20:00Z denotes UTC.
Include the recorded date and time in the reply. A date from the previous day would have exposed the fault immediately.
‹
Case 9/11
›
A project by Eniun