Book a Room template - UTC Time issue

[leslie_rivera]

I am using the Book a Room template and the Auto-response sent reflects the time in UTC. How can I get it to reflect my local time? Mountain Time??

[leslie_rivera]

How and where do I add Timezoneoffset?

[leslie_rivera]

@v-bofeng-msft.. can you help me with this one? I am struggling to figure out how to fix this UTC issue. Not sure how and where to add the Timezoneoffset.

[leslie_rivera]

I tried putting in TimeZone: "Mountain Standard Time" but then it booked my 1030am meeting to 430pm

[leslie_rivera]

Where do i put the minutes to reflect Mountain Standard Time (UTC-0:00)?

[leslie_rivera]

Solution:

If(
IsBooking,
UpdateContext({ShowLoading: true});
If(
!BookForMeeting,
Office365.V4CalendarPostItem(
MyCalendar,
User().FullName & "'s Booking",
StartDateTime,
EndDateTime,
"Mountain Standard Time",
{
requiredAttendees: RoomsGallery.Selected.Email,
location: RoomsGallery.Selected.Name,
importance: "normal",
showAs: "busy"
}
),
ClearCollect(
RequiredAttendeesNoRoom,
Split(
MeetingsGallery.Selected.RequiredAttendees,
";"
)
);
ForAll(
AllRooms,
RemoveIf(
RequiredAttendeesNoRoom,
Address = Result
)
);
ClearCollect(
RequiredAttendeesNoRoom,
Concat(
RequiredAttendeesNoRoom,
Result & ";"
)
);
ClearCollect(
RequiredAttendeesNoRoom,
Split(
First(RequiredAttendeesNoRoom).Value,
";;"
)
);
Set(
RequiredAttendeesFinal,
First(RequiredAttendeesNoRoom).Result
);
Set(
RequiredAttendeesTrue,
RoomsGallery.Selected.Email & ";" & RequiredAttendeesFinal
);
Set(
OriginalBody,
Office365.V3CalendarGetItem(
MyCalendar,
MeetingsGallery.Selected.Id
).body
);
Office365.V4CalendarPatchItem(
MyCalendar,
MeetingsGallery.Selected.Id,
If(
MeetingsGallery.Selected.Subject = User().FullName & "'s Zoom Meeting",
User().FullName & "'s Booking",
MeetingsGallery.Selected.Subject
),
StartDateTime,
EndDateTime,
"Mountain Standard Time",
{
requiredAttendees: RequiredAttendeesTrue,
optionalAttendees: MeetingsGallery.Selected.OptionalAttendees,
body: OriginalBody,
location: RoomsGallery.Selected.Name,
importance: "Normal",
showAs: "Busy",
isHtml: true
}
)
);
UpdateContext({ShowLoading: false})
);
Set(
IsBooking,
false
)

[leslie_rivera · Accepted solution]

See attached solution (had to change to V4, then hard coded mountain time)

[jharville]

@leslie_rivera 

I've tried using your solution in my code and have had no luck so far. Where would I put in the "Eastern Time Zone" portion of code?

Thank you so much,

Justin

[shafik]

Same issue with me. I am trying to change the time to GMT+5 but do not know where to change.

If any one know, please guide.

[leslie_rivera]

@jharville I update the Time Zone on the "ConfirmationScreen", On Visible... so for example if I wanted to change it to Eastern.. I would put "Eastern Standard Time" in both places.