Unanswered

I want to create a 365 group calendar event with my time zone not UTC

(0) Share

Report

Posted on by MA-17101414-0

Hi all, I am trying to create a flow that creates a group event when a new response is sent from Microsoft Forms. I want to create the group event with my time zone (UTC -5), however no matter what I do to specify the time zone, the group event is created with UTC time zone, I have seen that other people also had the same problem, and the solution was to use the action 'Send an HTTP Request', but I do not know how it works, it would be of great help if you can explain me how it works, if you have link to articles or videos that explain, it would be of great help, thank you very much.

Categories:

Building flows

imagen_2024-10-17...

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
I don't know what you've looked at with regard to doing this with an HTTP request, so I cannot comment on that. However, I think you will find that you want to store the dates in UTC time because when you open the event in Outlook, it will adjust the time based on your time zone.

But if you really want to adjust the time zone, you can do that with expressions:

Say you want to create a one-hour meeting, two hours from now, the expressions would be (adjusting Eastern Standard Time to the time zone of your choosing):

Start Time: convertTimeZone(addHours(utcNow(), 2), 'UTC', 'Eastern Standard Time')

End Time: convertTimeZone(addHours(utcNow(), 3), 'UTC', 'Eastern Standard Time')

I just ran this at 12:42 PM ET, and because of the conversion, it shows in my calendar as:

By not adjusting the time, it shows up at the correct time:

Was this reply helpful? Yes No
MA-17101414-0 12 on at

Like (0)

Report
I have tried all these expressions, are ordered from the first one I used to the last one I used:
formatDateTime(addMinutes(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 480), concat(formatDateTime(utcNow(), 'yyyy'), '-', 'MM-ddTHH:mm:ss')) formatDateTime(addMinutes(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 480), concat(formatDateTime(addHours(utcNow(), -5), 'yyyy'), '-', 'MM-ddTHH:mm:ss')) concat(formatDateTime(convertFromUtc(utcNow(), 'SA Pacific Standard Time'), 'yyyy'), '-', formatDateTime(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 'MM-ddT08:00:00')) concat(formatDateTime(convertFromUtc(utcNow(), 'America/Bogota'), 'yyyy'), '-', formatDateTime(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 'MM-ddT08:00:00'))
This one was wrong:
concat(formatDateTime(convertFromUtc(utcNow(), -5), 'yyyy'), '-', formatDateTime(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 'MM-ddT08:00:00'))
This isn't wrong:
concat(formatDateTime(addHours(utcNow(), -5), 'yyyy'), '-', formatDateTime(body('Obtener_los_detalles_de_la_respuesta')?['red5d742076fa403b87703117c5325c35'], 'MM-ddT08:00:00'))
Every expression except the wrong one created the event but still using UTC as time zone, as I said I want create events for birthdays at a specific time (8:00AM - 8:30AM) using my time zone (UTC -5, SA Pacifict Standard Time)

Was this reply helpful? Yes No