Hello all,
I have a 'Book a Room' app that sounds out meeting invites to Outlook once a room is selected & booked. My only issue is I believe the default time-zone for meeting time is UTC. Here is a screenshot of the Outlook meeting invite:
I've tried using the solution from this forum post but have had no luck fitting it into my code:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Book-a-Room-template-UTC-Time-issue/m-p/1200139#M314676
Here is my code:
Set(
AllRoomsConnector,
Concat(
FirstN(
AllRooms,
20
),
Address & ";"
)
);
Concurrent(
ClearCollect(
AvailableRooms,
Office365Outlook.FindMeetingTimes(
{
RequiredAttendees: AllRoomsConnector,
IsOrganizerOptional: true,
Start: StartDateTimeUTC,
End: EndDateTimeUTC,
MeetingDuration: DateDiff(
StartDateTime,
EndDateTime,
Minutes
),
MinimumAttendeePercentage: "1",
ActivityDomain: "Unrestricted"
}
)
),
If(
CountRows(AllRooms) > 20,
If(
CountRows(AllRooms) > 40,
Set(
AllRoomsConnector1,
Concat(
LastN(
FirstN(
AllRooms,
40
),
20
),
Address & ";"
)
),
Set(
AllRoomsConnector1,
Concat(
LastN(
AllRooms,
CountRows(AllRooms) - 20
),
Address & ";"
)
)
);
ClearCollect(
AvailableRooms1,
Office365Outlook.FindMeetingTimes(
{
RequiredAttendees: AllRoomsConnector1,
IsOrganizerOptional: true,
Start: StartDateTimeUTC,
End: EndDateTimeUTC,
MeetingDuration: DateDiff(
StartDateTime,
EndDateTime,
Minutes
),
MinimumAttendeePercentage: "1",
ActivityDomain: "Unrestricted"
}
)
),
Clear(AvailableRooms1)
)
);
If(
CountRows(AllRooms) > 20,
Collect(
AvailableRooms,
AvailableRooms1
)
);
ClearCollect(
AvailableRoomsSorted,
SortByColumns(
First(AvailableRooms).MeetingTimeSuggestions,
"Confidence",
Descending
),
If(
CountRows(AllRooms) > 20,
SortByColumns(
Last(AvailableRooms).MeetingTimeSuggestions,
"Confidence",
Descending
)
)
)
);
I've even tried changing those 4 instances in my code where it says "StartDateTimeUTC" and "EndDateTimeUTC" to "StartDateTime" and "EndDateTime" , and although it doesn't error out, the meeting invite still shows the UTC time-zone.
Everything in the code is functional, but I just want to change the UTC time-zone to Eastern Standard Time. Would anybody know how to do that?
Thank you so much,
Justin
