web

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

News and Announcements icon

Power Platform CommunityForums Power Automate OData Date Range

Power Automate

Answered

OData Date Range

(0) Share

Report

Report

Posted on by Cjohnson20

31

I am trying to make an Odata filter that will only take data entered within the last week from my source so instead of a specific date range it is a rolling range from 'Today'. Is that possible?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ellis Karim 12,288 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
You can use the utcNow() to get the current date and addDays() function to add or substract days from the current time.

addDays(utcNow('yyyy-MM-dd'), -7)

For example, in the following filter query I am searching for items that were created between today (2022-03-16) and 2022-03-09:

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Cjohnson20 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Ellis. This worked in my flow. Thanks for the help.

Join the conversation