Difference between start time on Bookings and Power automat flow

[slach84]

Hi!

I have a problem with Power Automate and Bookings.

I have created a calendar for booking appointments on Bookings configured in GMT+1 (Paris, Brussels, Madrid)

I have configured a flow that informs our team on Teams when an appointment is booked, modified or cancelled via Bookings. I selected the "start time" Bookings trigger output to view the time of the scheduled appointment.

However, when the Teams notification sent by Power Automate is displayed, it systematically shows two hours ahead of the correct time selected by the client.

How can I fix this?

Thanks for your help !

[Heartholme · Accepted solution]

Hi @slach84 ,

You can add a "Convert time zone action" which takes the calender and then select your desired format, and source and destination time zone as the same. As you can see from below it automatically adjust the time from 11 (UTC) to 13 (UTC+01+Summertime)

This will also dynamically adjust daylight savings, IE. 1 hour in the winter difference between UTC and 2 hours in the summer, for this time zone. 

Then display the output from the convert time zone, together with your other information in the teams notification.

✔ Marking my post as a solution not only confirms that your question has been answered, but also helps others find solutions to similar problems.
By doing so, you'll be making a valuable contribution to the community.

Best Regards
Heartholme

[slach84]

Thank you so much @Heartholme , it works like a charm ! You rock 😉

[Heartholme]

@slach84 Great! Glad to hear 😄

[JamSeb]

A note for anyone with a similar problem - 

I used @Heartholme's solution, but without the Compose utcNow() step (which pulled the current date and time), and instead used the "Start time and time zone" from Bookings as the Base Time to convert.