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

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
Frequent Visitor

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
Frequent Visitor

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

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

Frequent Visitor

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

 

Thanks!

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,755)