web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Answered

Get Items - Dates

(0) ShareShare
ReportReport
Posted on by 394 Super User 2024 Season 1

Dear All,

 

I have a power automate with get items which I need to filter a SharePoint list. The filter needs to filter records if todays date is in between two columns Start Date and End Date.

 

How is best to filter query this?

 

Kind Regards

 

Daniel

Categories:
I have the same question (0)
  • abouchaalaBAIT Profile Picture
    932 Moderator on at

    Hello @DLCaterhamSch 

    Here is my test list 

    abouchaalaBAIT_0-1705673368235.png

    And here is the flow

    abouchaalaBAIT_1-1705673408957.png

    using this filter, you will be able to get only items where Start date < utcnow() and EndDate > utcnow() 

    (StartDate lt '@{utcNow()}') and (EndDate ge '@{utcNow()}')

     Hope this helps

    ----------------------------------------------------------
    If I have answered your question, please mark your post as Solved. 🆗✔️
    If you like my response, please give it a Thumbs Up. 👍
    You can accept more than one post as a solution.

  • Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at

    In the "Get items" set a (ODATA) filter query like this:

    StartDate lt '@{utcNow()}' and EndDate gt '@{utcNow()}'

     

  • Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at

    🤣

  • abouchaalaBAIT Profile Picture
    932 Moderator on at

    🤣🤣🤣

  • DLCaterhamSch Profile Picture
    394 Super User 2024 Season 1 on at

    This is definetely the closest got to this. It doesnt work if the start date is today and end date is today though?

  • Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at

    Since utcNow() has a time, the first part 

    StartDate lt '@{utcNow()}'

    includes the start date (if it's without time or 0:00).

    To have the second part including the end date you need to add a day to utcNow() and use startOfDay() if also the hours matter.

  • DLCaterhamSch Profile Picture
    394 Super User 2024 Season 1 on at

    Sorry I dont understand?

  • Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at
  • Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at

    If StartDate includes a time other than 0:00 h you have to add a day there, to check if it's less than tomorrow.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard