cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leslie_rivera
Resolver II
Resolver II

Book a Room template - UTC Time issue

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_0-1620947838841.png

leslie_rivera_0-1620963695000.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
leslie_rivera
Resolver II
Resolver II

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

View solution in original post

7 REPLIES 7
leslie_rivera
Resolver II
Resolver II

How and where do I add Timezoneoffset?

leslie_rivera_0-1621011846400.png

 

leslie_rivera
Resolver II
Resolver II

@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
Resolver II
Resolver II

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

leslie_rivera_0-1621269442380.png

 

 

leslie_rivera_1-1621269461060.png

 

leslie_rivera
Resolver II
Resolver II

leslie_rivera_0-1621356035427.png

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

 

leslie_rivera
Resolver II
Resolver II

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
Resolver II
Resolver II

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

@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?

 

jharville_0-1652980131303.png

 

Thank you so much,

 

Justin

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,032)