Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Create an even is not posting into all dates

(0) ShareShare
ReportReport
Posted on by 6
Hi
 
I'm using this lovely action - The problem is - if it is a 2 day holiday for example 16/12/2024 - 17/12/2024 it is only posting the event in 16/07/2024
 
Same with others, it always posts the last date in the day before...
 
  • Suggested answer
    EKarim Profile Picture
    EKarim 10,457 on at
    Create an even is not posting into all dates
     
    Try: Add 1 day to the end date
     
    This is because:
     
    Start time: 2024-12-16 actually means 2024-12-16T00:00 midnight
    End time: 2024-12-17 actually means 2024-12-17T00:00 (midnight)
     
    The end date needs to be: 2024-12-18 (2024-12-18T00:00)
     
     
     
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 234 on at
    Create an even is not posting into all dates
     The issue you are experiencing in your "Create event (V4)" action within Power Automate often happens due to how the Start time and End time are calculated or passed. This causes a mismatch, particularly when dealing with multi-day events or inclusive ranges. Outlook calendar events treat Start time and End time as an exclusive range, Try below solution
     
     
    1. In the Create event (V4) action, ensure the Start time is set to the first day at midnight:
        formatDateTime(variables('StartDate'), 'yyyy-MM-ddT00:00:00')
        
    2. For End time, use an expression to add one day to the last day and set the time to 00:00:00:
        formatDateTime(addDays(variables('EndDate'), 1), 'yyyy-MM-ddT00:00:00')
        
    3. Use the adjusted Start time and End time in the action.
     
    4. Verify the Time Zone matches the desired location.
     
    This ensures the event spans all days and ends at 23:59 on the final day.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard