cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maxze
Level: Powered On

Sharepoint calendar get events, when multiple all-day event

Hi,

 

I currently have a Flow which checks the upcoming events on the following day. I use the "Get items" action and a Filter query to get events which take place between 00:00:00Z and 23:59:00Z. So it looks like this:

EventDate ge '//function to get 00:00:00Z' and EventDate le '//function to get 23:59:00Z'

So it is no problem to get all-day events. But the flow doesn't get events which are multiple days long. So if an event starts at 04.29.2019 and ends on 05.02.2019 and I check for the 1st of May the event will not come up. Is there a query operator to check if the checked date is in the timespan of the multi-day event?

 

Thanks for help

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
maxze
Level: Powered On

Re: Sharepoint calendar get events, when multiple all-day event

After some testing I acutally figured out a way that works. 

I check if there is an event with EventDate (start date) less than the checked Date and a EndDate greater than the checked date:

 

EventDate lt 'checkedDate' and EndDate gt 'checkedDate'

View solution in original post

3 REPLIES 3
Highlighted
maxze
Level: Powered On

Re: Sharepoint calendar get events, when multiple all-day event

After some testing I acutally figured out a way that works. 

I check if there is an event with EventDate (start date) less than the checked Date and a EndDate greater than the checked date:

 

EventDate lt 'checkedDate' and EndDate gt 'checkedDate'

View solution in original post

kklink
Level: Powered On

Re: Sharepoint calendar get events, when multiple all-day event

@maxze do you mind explaining this a little more? where do you put in your new expression and what is checked date?

sarshad
Level: Power Up

Re: Sharepoint calendar get events, when multiple all-day event

Hi is there any way you elobrate on your solution? Can you post a screenshot of this flow working?

 

Thanks!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 380 members 6,521 guests
Recent signins:
Please welcome our newest community members: