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
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (2,431)