Unanswered

Prevent double booking SharePoint calendar for the day

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

The goal of the flow is to prevent double cooking if the category has been assigned for the day (no need to check time) of the calendar. This is what I have so far. If the category is chosen, do not save the item, send email about the double booking.

So for example, April 10, 2019, Category = Meeting then someone trying to book again for the same day and trying to choose Category = meeting, do not save, send email.

Thanks for the help.

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to check if the selected category already exists or not? If it already exists (for the same day), delete the newly added one and send an email, stopping double booking.

I have set up the flow likes below. In the following scenario, I am going to check the booking for the same day and stop duplicate booking for one category.

Add trigger When an item is created or modified. Manually enter the name of the calendar list.

Add action Get items, input the code likes below in the Filter query field to filter out events that start on the same day and with the same category.

Then add a Condition with following code:

length(body('Get_items')?['value']) is greater than 1

Under if yes branch, add action Delete item. Make sure select dynamic content ID from the trigger.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for this reply. I followed your flow but somehow, the yes condition is not working. Section value is a lookup field.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The yes condition is working now but the original copy is the one getting deleted. I double checked the correct ID is used.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Looks like I got some parts to work now but I am having an issue with infinite loop of flow for the NO condition since an Update Item action is considered "MODIFIED" so it will go to the top and run the flow again and again.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I think the condition is not working because it is deleting all the entries for the day.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thanks for updating.

In the action Delete item, please make you select the dynamic content ID from the trigger, then it will only delete the newly created one when the condition match.

If you want to update item under If no branch, to get rid of an infinite loop, pleas change the trigger to “When an item is created”.

I have made another test and it does work as expected.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for this reply. I got this create item trigger to work but the problem is when a user modify an item, this trigger..

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I guess that you are using the trigger “When an item is created or modified”. If so, the flow will be triggered whenever a new item is created or an existing item is modified.

I suggest use the trigger “When an item is created” so that the flow won’t be triggered when the existing items are updated/modified.

Hope this make sense.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

because create or modified triggers are required to make sure no double booking of the section or category.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I got it. How about removing the action Update item?

Without using the action Update item, the flow won’t be triggered infinitely.

Best regards,

Mabel

Was this reply helpful? Yes No