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 Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,318)