Unanswered

'Create event (V4)' Always Sets the Wrong Time

(0) Share

Report

Posted on by JayRenn

I'm trying to set appointments using data from a spreadsheet. The appointment start time is formatted like "2/27/2025 13:00". The 'Time zone' field is set to Central Time.

No matter what expression Copilot suggests, the appointment is always set for 6:00 am instead of 1:00 pm. Here are two examples I would expect to yield different start times but they both set the appointment to 6:00 am:

formatDateTime(convertTimeZone(items('Apply_to_each')?['Appointment'], 'UTC', 'Central Standard Time'), 'yyyy-MM-ddTHH:mm:ssZ')

formatDateTime(convertTimeZone(items('Apply_to_each')?['Appointment'], 'Central Standard Time', 'UTC'), 'yyyy-MM-ddTHH:mm:ssZ')

How do I ensure that "13:00" is added to my calendar at 1:00 pm?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

Do not do any conversion of the date. Just format the date as it is shown in the action and select the time zone:

In other words: 2025-02-19T13:00:00 (yyyy-MM-ddTHH:mm).

If you are doing the time zone conversion to get the time to be 13;00, then double-check that your expression is returning that value and it is formatted as above without the Z at the end, which indicates UTC. You can check this by adding your expression to a compose action. When you review the flow run, you can easily see what the expression passed to the create event action.

Was this reply helpful? Yes No
JayRenn 2 on at

Like (0)

Report

Your suggestions worked, but then I decided I would make more sense to have the user launch a flow within Excel, so I built a new Power Automate flow from within Excel. Now all the dates are coming in as decimals, and neither copilot nor chat GPT have any idea how to convert them correctly. How do I change a decimal date/time into a string date/time with the format "yyyy-MM-ddTHH:mm"? It certainly isn't any of these options:

formatDateTime(convertTimeZone(items('Apply_to_each_Row_in_the_Table')?['Appointment'], 'Central Standard Time', 'UTC'), 'yyyy-MM-ddTHH:mm:ssZ')

formatDateTime(items('Apply_to_each_Row_in_the_Table')?['Appointment'], 'yyyy-MM-ddTHH:mm:ss')

Was this reply helpful? Yes No