web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items Date Range F...

Power Automate

Answered

Get Items Date Range Filtering

(0) Share

Report

Report

Posted on by wchev

16

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation