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??
Solved! Go to Solution.
See attached solution (had to change to V4, then hard coded mountain time)
How and where do I add Timezoneoffset?
@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.
I tried putting in TimeZone: "Mountain Standard Time" but then it booked my 1030am meeting to 430pm
Where do i put the minutes to reflect Mountain Standard Time (UTC-0:00)?
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
)
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
184 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
240 | |
74 | |
71 | |
69 | |
65 |