Calendar Problems

Fix Power Automate Repeating All-Day Calendar Events Spanning Two Days

Rana Garcia Sep 28, 2026 868 views

Question details

The user is experiencing an issue where a Power Automate flow designed to create repeating all-day calendar events renders the final two events as two separate days.

How to Fix Power Automate Repeating All-Day Events Ending as Two Days

Product: Power Automate
Device & OS: not provided
Scenario: Using a Power Automate flow to dynamically generate and schedule repeating all-day events in a calendar.
Observed behavior: The calculated EndDate value shifts into the following day due to extra time or milliseconds in the calculation, causing the event to span across two days instead of one.

Before you start

Ensure you have editing access to the specific Power Automate flow and verify that the timezone settings in your Microsoft environment are configured correctly.

Solution 1Recommended

Adjust the End Time Expression to Prevent Midnight Rollover

Modify the flow's date calculation to set the end time slightly before midnight, stopping milliseconds from pushing the date into the next day.

When using the AddDays function in Power Automate, the time component is retained. If milliseconds push the calculated time past 23:59:59, the calendar recognizes the event as extending into a second day. Hardcoding the end time to 23:58 effectively prevents this.

Edit Your Flow

Log in to Power Automate, navigate to 'My flows', and select the flow that creates the repeating calendar events to enter edit mode.

Locate the Date Calculation

Find the specific step or action (such as 'Create event' or 'Compose') where the EndDate is being calculated, usually involving an AddDays expression.

Modify the End Time

Adjust the time formatting or the expression output to explicitly set the end time to 23:58. For example, concatenate your formatted date string with 'T23:58:00Z'.

Save and Test

Save your flow changes and run a manual test. Verify in your calendar that the final generated all-day events now correctly display as a single day.

Adjust the End Time Expression to Prevent Midnight Rollover

Expression Adjusted Successfully: Setting the time to 23:58 guarantees the final event closes before the next day officially begins, resolving the two-day visual bug.

Solution 2

Request Specialized Help in the Power Automate Community

If adjusting the time does not resolve the complex date logic, consult flow experts in the official Microsoft community.

Free Microsoft Office alternative

Manage Schedules and Data Seamlessly with WPS Office

While specialized automation logic requires Microsoft tools, WPS Office provides a free, lightweight, and highly compatible suite for all your standard planning, scheduling, and document management needs.

1. Download WPS Office: Visit the official WPS Office website and click 'Download WPS Office Free' to get the installer.
2. Install the Suite: Run the downloaded installation file and follow the on-screen prompts to set up the software on your device.
3. Start Managing Schedules: Open WPS Spreadsheet, choose a calendar or planner template, and effortlessly track your daily events without writing complex flow expressions.

Easily plan and track calendar events manually using flexible spreadsheet templates without needing complex automation logic.Fully compatible with Microsoft Excel, Word, and PowerPoint document formats.Lightweight software architecture that runs smoothly on almost any desktop or mobile operating system.Familiar, tabbed user interface for effortless navigation and minimal learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Power Automate AddDays expression push my event to the next day?

The AddDays function calculates time down to the exact millisecond. If your base calculation starts late in the day or picks up extra milliseconds during processing, adding 24 hours can unintentionally push the final calculated timestamp just past midnight, triggering the calendar to display it as a two-day event.

Can I format dates in Power Automate to completely strip out the time?

Yes. You can use the formatDateTime() expression with a format string like 'yyyy-MM-dd' to remove the time component entirely. This helps prevent unintended timezone shifts or time-of-day crossovers when passing values to calendar connectors.

How do I ensure an event is recognized as 'All-Day' in the calendar connector?

When creating an event using a calendar connector in flow, ensure that the 'Is All Day' parameter is explicitly set to 'Yes'. Additionally, ensure the Start Date and End Date are cleanly formatted without conflicting time data that overlaps into the next calendar day.

Outlook & Email Problems