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'
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'
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
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 387 members 4,904 guests
Please welcome our newest community members: