Showing results for 
Search instead for 
Did you mean: 
New Member

Get all existing events based on a new holiday request being added to sharepoint calendar



I am looking to return all existing items on a sharepoint calendar when a new vacation request has been added.

I have it partially working using an odata filter but it only returns items that the event date matches.


Can anyone help me get all existing events that occur when a new entry is added

The entry has to include events that overlap the vacation request being entered


John wants the 21st to 23rd of feb

Brian is already in the calendar until 22cnd of feb

Peter is in the calendar from the 20th of feb until 26th of feb.


I need to return all items in an email to notify that


John has requested 21st to 23rd

People already off 

Brian 19th - 22cnd

Peter 20th - 26th







Community Support
Community Support

Hi @MrC,


Could you please share more details about your requirement?

I couldn't understand your requirement from your description,please share more details so we would try to provide a proper workaround for you.


Best regards,


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,355)