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.
Any ideas or good references for how to do this?
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 ?
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.
How would you convert this for Eastern Standard Time?
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.
Share
Report
All responses (
Answers (
adddays(utcnow(),1)adddays(utcnow(),6)
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
@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?
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:
If you have found my post helpful, please mark thumbs up.
Any other questions, just ask.
Thanks, Alan
Happy Flowing!
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
