Unanswered

Find Meeting Time During Working Hours

(0) Share

Report

Posted on by knu2xs

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?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

AlanPs1 2,471 on at

Like (2)

Report
Copy link

Link copied!
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".

8am

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

5pm

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

As you will see below:

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

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#date-and-time-functions

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

Any other questions, just ask.

Thanks, Alan

Happy Flowing!

Was this reply helpful? Yes No
Asuncion 32 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Asuncion

Have a look at this video by @RezaDorrani : https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Microsoft-Flow-to-block-available-time-quot-Focus-Work-quot-on/m-p/391272
Maybe it could help in setting the right expressions.
Hope it helps!
Ferran

Was this reply helpful? Yes No
NickTT 236 on at

Like (0)

Report
Copy link

Link copied!
I have a requirement to get a meeting scheduled in the next 6 days after a document is approved. I currently use the Find Meeting Times (v2) action to find 1 available slot and automatically schedule a Teams meeting on the required peoples calendar. The issue I am running into, is that sometimes it picks meeting times after working hours. For instance 7:30 PM. Is it possible to narrow this down to just 9am-4pm window in the next 6 days or do I need to filter the returned results after?

I am currently using the follow start and end ranges in the action.
adddays(utcnow(),1)
adddays(utcnow(),6)

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Thoman

Please, create a new post with your question, so it will be easier for others to help you and will keep the content organized.

Regards,

Ferran

Was this reply helpful? Yes No
AmandaAustin 2 on at

Like (0)

Report
Copy link

Link copied!

How would you convert this for Eastern Standard Time?

Was this reply helpful? Yes No
LLMaeder 18 on at

Like (0)

Report
Copy link

Link copied!

Hey guys,
@knu2xs @AmandaAustin @fchopo @Thoman @Asuncion
i have a similar problem and im trying to fix it for a long time :(. I also want to find meeting times and automatically create a meeting in the calendar of both attendees (who filled out a form before). the whole flow works but it alaways books meetings on already exisiting meetings in the calendar. I would really really appreciate if someone of you has an idea how to fix it.

Was this reply helpful? Yes No
NickTT 236 on at

Like (0)

Report
Copy link

Link copied!

I ended up setting up find time to return 999 results then used a filter to find the first free 3PM time slot. It's not the best but it works and now all my employee reviews are schedule for 3PM 🙂

Was this reply helpful? Yes No
BigMo 5 on at

Like (0)

Report
Copy link

Link copied!

I am basically doing the same thing and i am getting all the results but the main problem that i am having at the moment is returning the information to power apps . i have tried absolutely everything but can't get the results into a collection. in the right format and there are no results showing up in the gallery. can anyone help ?

Was this reply helpful? Yes No