Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Find Meeting Time During Working Hours

All I'm trying to do is have a Flow to check my Office 365 Calendar every day before I get up and schedule a block of time to go do a workout around my work obligations. However, I cannot seem to figure out how to specifiy the window from 08:00-17:00, and I cannot seem to find the documentation detailing this, either.


Screen Shot 2019-03-22 at 12.25.55.png


Any ideas or good references for how to do this?

Super User
Super User

Re: Find Meeting Time During Working Hours

Hi there. Thank you for your post.

I have edited this reply as it wasn't concise enough (on my part) and could have been a tad misleading.


Below should be a solution for you. I am in the UK although have added the code to convert to "Pacific Standard Time".Capture-412.png


addHours(startOfDay(formatDateTime(convertTimeZone(utcnow(), 'UTC', 'Pacific Standard Time')), 'HH:mm'), 😎


addHours(startOfDay(formatDateTime(convertTimeZone(utcnow(), 'UTC', 'Pacific Standard Time')), 'HH:mm'), 17)

As you will see below:Capture-411.png

You may want to format the time and date a little so here is a link to the documentation that you are missing:


If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

Happy Flowing!

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Level: Powered On

Re: Find Meeting Time During Working Hours

@AlanPs1 - I was able to use your suggested expression to find meeting times within business hours, however, I noticed the output is giving a time suggestion that has passed from earlier this morning. 


Is there a way to rewrite the expression including getFutureTime adding 1 day within business hours? 

Level 8

Re: Find Meeting Time During Working Hours

Hi @Asuncion 


Have a look at this video by @RezaDorrani :

Maybe it could help in setting the right expressions.

Hope it helps!


Helpful resources


Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!


Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,594)