cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
Resident Rockstar
Resident Rockstar

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!


Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,388)