Unanswered

App creating meeting in Teams but start and end time showing 1hr behind

(0) Share

Report

Posted on by JimboSey

321

I have a PowerApp that is a course booking tool. Admins have a screen to Create a course, the issue I am having is when the course is created and people book on the course, the time of the meeting in Teams/Outlook is an hour behind what wa set when creating the course. However, I have a gallery in the my App that shows list of courses, and start and end times and they show as intended.

For example a course created and specified start time is 09:00 and end time 11:00, the meeting in Teams/Outlook will show as 08:00 - 10:00

I live in England, and my Time Zone is currently BST. Below is part of the code on the onselect of a button used to create the course....

//Run PowerAutomate
Set(PowerAutomateConfirmation,'TSPBookingApp-CreateCourse'.Run(TxtCourseName.Text & " - " & eventCourseTypePowerAutomate,Text(DteCourseDate.SelectedDate, "yyyy-mm-dd") & "T" & Text(DrpCourseStartTime.Selected.Value, "[£-en-UK]hh:mm:ss") & "+01:00",Text(DteCourseDate.SelectedDate, "yyyy-mm-dd") & "T" & Text(DrpCourseEndTime.Selected.Value, "[£-en-UK]hh:mm:ss") & "+01:00",ComTutorCreate.Selected.Email,eventCourseTypePowerAutomate,CohortPowerAutomate,StreamPowerAutomate,CourseDate,eventStartPowerAutomate,eventEndPowerAutomate,SpacesAvailable,TutourPowerAutomate.Claims,varDurationHours).confirmation);

If(PowerAutomateConfirmation = "Yes",Notify("Succcess: The course " & CourseNamePowerAutomate & " has been successfully created",NotificationType.Success));

The Timne Zone in my PowerAuotmate is UST.

Any ideas greatly appretiated?

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

jkic 150 on at

Like
a
(1)

Report
Copy link

Link copied!

If the times you are seeing are 1 hour behind UK then they are UTC time which is the 'default' time in Power Platform. This suggests you may be missing a parameter somewhere to tell Power Automate (or Outlook) the timezone of the time being supplied. I'd check if the time is correct when received by Power Automate i.e. Power Apps is passing the correct time, and therefore Power Automate is where the problem is, or is Power Apps passing the wrong time.
Jose Ramon 107 on at

Like
a
(0)

Report
Copy link

Link copied!
The problem is in the Power automate, not in the canvas application.

As far as I can see, there are two parameters in your Power Automate of type string, where you are passing the start date and the end date.
Make sure that the flow is getting the formatting you are sending from the canvas application correctly:
2023-10-26T16:30:00

In the flow add an action of type Date Time - Convert Time Zone for the start date and set the following values:
Base time: formatDateTime(XXX, 'yyyy-MM-dd HH:mm:ss tt') --> with the Start Date in your flow
Source time zone: select your time zone
Destination time zone: select (UTC) Coordinated Universal Time
Format string: put the expression 'yyyy-MM-dd HH:mm:ss tt'
Add again another action of the type Date Time - Date Time - Convert Time Zone for the end date and set the values

Now when you create the appointment, set as start time and end time, the result of the previous actions and with that, you will have it solved.
JimboSey 321 on at

Like
a
(0)

Report
Copy link

Link copied!

In my Flow, in the 'Create Teams Meeting' I changed the Time Zone from UTC to GMT Standard Time and removed the +1:00 from the code quote above, and this seems to of resolved it and working as intended now.

Thank you for getting back to me 🙂
Jose Ramon 107 on at

Like
a
(0)

Report
Copy link

Link copied!

It is best to work with UTC to avoid problems, especially in case of time changes and in case of shipments to other countries.
I'm glad you solved it