I have a flow that I've been running for a while that is triggered whenever a new event is added to my calendar that adds a 15-minute hold to my calendar before and after the event that was created. I do this to stop people from booking me in back to back meetings so I have time to travel between meeting rooms, so I can check in with my team if needed, check my email, etc.
The flow itself is built and I've been using it for about a year however I see a few opportunities for improvement that I'm hoping someone can help me with.
I cannot for the life of me figure out how to make flow check to see if there is a calendar conflict with the name "Hold" before creating the new 15 minute holds.
Can someone help me with this, please?
Thanks in advance.
Hi @johncbibbs , thanks for posting in the Flow Community.
I would suggest using "Get events (V3)", somewere in your Flow. Some info below:
Consider this view of the action using an Odata filter looking for Subect of "Hold" as you have suggested.
It returns the following:
I guess before you amend your Flow creates an event it looks in this way to see if one called Hold is there or not.
p.s. The filter can target other fields too, dates for example. Loads of information on the web about constructing the filter whether that be "filter query" or "order by" but here is a starting point - https://docs.microsoft.com/en-us/azure/search/query-odata-filter-orderby-syntax
Please let me know how you get on with this type of approach.
If you have found my post helpful, please mark thumbs up.
Any other questions, just ask.
How would this work? What I am trying to do is to get Flow to check and see if there is already a hold on my calendar that would conflict with the one that the automation is about to create and if so terminate the flow.
Here's an example.
If I have a one-hour long meeting on my calendar at 10:00 AM it will also have a pre-meeting hold at 9:45 AM- 10:00 AM and a post-meeting hold from 11:00 AM - 11:15 AM.
Now if someone else sends me a meeting invite for 11:15 AM because that is showing as my next availability I would end up with a second automatically created hold event on my calendar from 11:00 AM - 11:15 AM.
I'm trying to figure out how to get the system to go "There is already a hold scheduled during that time so I'm not going to create another."
At the end of the day, it's not a huge deal if it can't be done. It just means I have to go through once or twice a week a delete a few duplicate holds to keep my calendar clean.
Thanks for your help.
it made me laugh when I saw this... I've got exactly the same issue (back to back meetings), had exactly the same idea (using a flow) and have exactly the same problem (don't want to book a hold meeting over an existing one). I just wondered if you ever worked out a solution?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!