cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevenls
Helper IV
Helper IV

Calculating Timezone for a meeting based on a variable from a form

Hi there,

I have a flow that triggers based on the submission of a 'Form'.  This is part of the onboarding process and does a number of things, sends out a welcome email, adds the user to various teams and mentions them and setups up some recurring meetings.

The issue I have is the timezone for the meeting.

On the form we have a selection box for location "Sydney", "Vancouver" etc.  The form also captures the start date of the person which is adds to my problem 🙂

I need to schedule a meeting on their first day, a different meeting 2 days after they start and then a few recurring meetings.

I need to be able to take the variable that has the location and set the correct time zone and I also need to figure out if the meeting that is 2 days ahead is not on anyones weekend.

I am completely stuck on even where to begin with the last two points.

The flow works right the way through, just the meeting timezones and not being a weekend is challenging me.

 

This is what I have so far, but I think it is REALLY messy.  It works, i.e. if the person is set to vancouver the flow head best wato the No option and if in Sydney the meetings is created at 6:15 the day after for an 11:15am meeting in Vancouver.

Is this is the best way should I just nest a number of these convert time zones and create meetings in the Yes and No for the various meetings needed?

TimeZones.JPG

 

Thank you.

 

1 REPLY 1
stevenls
Helper IV
Helper IV

I am also not sure how to get the ID of the calenders in Teams I need to be able to setup the Flow to add the meeting to those calendars.

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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,304)