cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johncbibbs
Frequent Visitor

Check for Conflict When Creating a New Event

Hello,

 

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.

2 REPLIES 2
Super User
Super User

Re: Check for Conflict When Creating a New Event

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.Capture-543.png

It returns the following:Capture-541.png

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.

 

Thanks, Alan

 


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

Proud to be a Flownaut!


johncbibbs
Frequent Visitor

Re: Check for Conflict When Creating a New Event

Hi @AlanPs1,

 

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.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,553)