Calendar Problems

How to Fix Power Automate All-Day Events Ending on the Wrong Date

Maira Mehtab Sep 22, 2026 870 views

Question details

Users need to correct a Power Automate flow where generated all-day calendar events incorrectly span across two days.

Product: Power Automate
Device & OS: not provided
Scenario: Creating repeating all-day calendar events automatically using a Power Automate flow.
Observed behavior: The final events display as two days because the calculated end time inherently adds milliseconds, pushing the event past midnight.

Before you start

Review your Power Automate flow's date calculation expressions and note the exact time format being generated for the end time of your calendar events.

Solution 1Recommended

Adjust the Event End Time to Before Midnight

Modify the flow's end time calculation to stop slightly before midnight (e.g., 23:58) to prevent the event from rolling over into the next day.

When using functions like AddDays in Power Automate, the calculation can sometimes add hidden milliseconds. This pushes the event end time just past 00:00:00 of the next day, causing the calendar to display the event across two days.

Locate the time calculation step

Open your Power Automate flow and find the specific step where the calendar event end time is calculated.

Check the date expressions

Review the expressions used (such as the AddDays function) for the end date output to see if it implicitly includes time.

Modify the end time

Adjust the time component of your calculated end date to explicitly set it to 23:58 or 23:59 instead of midnight.

Test the flow

Save the changes to your flow and run a manual test to verify that the generated all-day events now correctly display on a single day.

Precision Check: Setting the time strictly to 23:58 effectively strips away the extra milliseconds that trigger the two-day rollover.

Solution 2

Seek Expert Help in the Power Automate Community

If adjusting the end time doesn't resolve the issue, consult the official community for flow-specific troubleshooting.

Free Microsoft Office alternative

Manage Your Schedules Seamlessly with WPS Office

While Power Automate handles complex workflow automation, managing your exported calendar data, schedules, and daily tasks is easier with WPS Office. It is a free, lightweight suite that is fully compatible with Microsoft Office formats.

1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install and launch: Run the installer and open WPS Office to access Writer, Spreadsheet, or Presentation modules.
3. Use schedule templates: Navigate to the Template store within the app and search for 'calendar' or 'schedule' to easily plan your events.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight and runs smoothly on Windows, Mac, and Linux.Provides a familiar UI for a seamless migration from Microsoft Office.Offers free built-in schedule templates to organize your events manually.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my all-day calendar events show up as two days?

This typically happens when the event's end time crosses midnight (00:00:00). Even a fraction of a millisecond past midnight will cause most calendar applications to extend the event into the following day.

Does the AddDays function in Power Automate add time?

Yes, depending on how it is formatted, the AddDays function can inherit the current timestamp or add milliseconds. It is best to explicitly format the output to reset the time component to exactly 00:00:00 or 23:59:00.

How can I format dates in Power Automate to remove the time?

You can use the formatDateTime function in your expression, such as formatDateTime(utcNow(), 'yyyy-MM-dd'), to strip out the time values and only pass the date to your calendar event.

Outlook & Email Problems