web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : fO2U1q4H333RqPIRnqRic2
Power Automate - General Discussion
Unanswered

Power Automate Creat Event V4 Date and Time Issue

Like (0) ShareShare
ReportReport
Posted on 10 Aug 2022 09:09:30 by 4

Hello, 

I hope somebody here can help me. 

 

I´m trying to create an Outlook event with Power Automate. 
The trigger I use is the SQL 'When an item is created (V2)' as seen in the picture below.

 

Unbenannt.PNG

 

Now here comes the problem:

When testing the flow the event gets created but the event time somehow gets messed up.

 

Input and output show the time i like the event to be created as seen below:

 

Unbenannt1.PNG

Unbenannt2.PNG

Yet in the Outlook Calender view it is off. Somehow 2 hours get added to "start date" and "end date" resulting in the event starting. 

Important is that i dont want to create an all day event.  

 

Now comes the weird thing. As soon as i open the event from the calendar view the time is displayed as I wanted the event to be:

 

Unbenannt4.PNG

I already tried to convert the time zones and what not.

 

Thanks in advance.

  • SamuelBenjamin Profile Picture
    69 on 02 Feb 2023 at 18:37:50
    Re: Power Automate Creat Event V4 Date and Time Issue

    Yep, something weird with the way PA manage dates.

    Create an event (v4):
    -Input 9.45am Berlin Time as start time, this are the outputs:

      "subject": "Test Convert to UTC",
      "start": "2023-02-02T09:45:00.0000000",
      "end": "2023-02-02T10:30:00.0000000",
      "startWithTimeZone": "2023-02-02T09:45:00+01:00",
      "endWithTimeZone": "2023-02-02T10:30:00+01:00",



    Get an event (v3) to get the event details on the step above. Totally weird!!

            "subject""Test Convert to UTC",
            "start""2023-02-02T08:45:00.0000000",
            "end""2023-02-02T09:30:00.0000000",
            "startWithTimeZone""2023-02-02T08:45:00+00:00",
            "endWithTimeZone""2023-02-02T09:30:00+00:00",

    Update and event (v4) to update the event on the first step. I use the start and end values from the get an event step. This is the ouput, but the event is still showing at 9:45 on my calendar.
            "subject""Test Convert to UTC",
            "start""2023-02-02T08:45:00.0000000",
            "end""2023-02-02T09:30:00.0000000",
            "startWithTimeZone""2023-02-02T08:45:00+00:00",
            "endWithTimeZone""2023-02-02T09:30:00+00:00",

    Is there something I'm missing out about how to manage calendar events with PA??
  • Madddi43 Profile Picture
    4 on 10 Aug 2022 at 10:17:44
    Re: Power Automate Creat Event V4 Date and Time Issue

    Update:

     

    Just noticed that the time zone in the opened event is set as utc. As soon as i manually change that, the calendar view gets updated to the right time. 

    Still dont know why that happens because I set the time zone to UTC+1 in the create event action. 

    So help is still appreciated.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete