Unanswered

Odata filter query help— less than or equal to today plus 7 days

(0) Share

Report

Posted on by Hclor

Hi there. I am new to this and need to create an expression to only get items whose column "Next Maint. Due" is less than or equal to 7 days from now. What would I put in the filter query field of the get items step? I've tried a number of things that haven't worked.

And would having an initialize variable before or after this affect it? Essentially my end goal is to send a weekly email with a table of all items due this week (or over due). I can post links to videos I've been referencing to help with this, but right now I'm stuck on what to put in the filter query field.

Thank you!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (2)

Report
You can start b:
getting the current date/time (this will be in UTC time).
converting the current date/time (UTC) to for your time zone
Adding 7 days to the current date/time in your time zone
Specify the OData filter query using the internal SharePoint column name of the "Next Maint. Due" column and your calculated date
For example:
Then in your Get items filter query, add the SharePoint column name and date (enclose the date in single quotes). For example, Created date is less than or equal to the calculated time:

You will need to use the internal column name for "Next Maint. Due". To find the internal column name of "Next Maint. Due" see How to find the internal name if a SharePoint Column.

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.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report
Hi @Hclor

What you need to do is to to use the Get Future Time action to get the time in 7 days as below

Then GetItems should look like below:

Expression 1:

formatDateTime(utcNow(),'yyyy-MM-dd')

Expression 2:

formatDateTime(body('Get_future_time'),'yyyy-MM-dd')

Note: Please note the single quotes around the formatdatetimeexpressions

Was this reply helpful? Yes No
kmw1130 988 on at

Like (0)

Report

I am trying to get SharePoint List items that are 7 days prior to start date AND 7 days after start date. This is what I currently have for Get Items and not sure it is working correctly:

Filter Query:
ge
formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')

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

1 people found this reply helpful.

Was this reply helpful? Yes No