Get Items Date Range Filtering

(0) Share

Report

Posted on by wchev

Hi all,

I'm after some advice please, I've read up on filter queries using SharePoint Get items and filtering using a date range. My data has 'Event Start' date and 'Event End' date. I need to run a flow every day which gets the items for the next three days, including those that are already in progress, which could be multi day or week long events.

I am able to get events where the event start is today +3 but not sure how to also pull in those that have already started but not passed the event end date.

What's the best way of doing this?

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Re: Get Items Date Range Filtering

Hello @wchev ,

you can use the approach explained here, the filter must use two values to create a range, e.g.

StartDate gt '<today>' AND EndDate lt '<today+3>'

Was this reply helpful? Yes No