Get Items Query include items due today

(2) Share

Report

Posted on by FW-07051511-0

160

Hello,

I have a list of tasks that have a due date. In my flow I am using Get Items with a Filter Query where DueDate le 'utcNow()'. It is getting all the appropriate records except the ones due today. The due date is a date/time column with time.

How do I get the list of items to include today's items.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

The time is taken into consideration with this query. So you need to wrap utcNow() inside of a startOfDay() expression so the time is set to midnight, or for today, it will return 2026-05-29T00:00:00Z.

e.g., startOfDay(utcNow())

Was this reply helpful? Yes No
Verified answer

Tomac 4,153 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @FW-07051511-0

There are a few ways to do this. First is to use FormatDateTime() to set the hour to 11:59PM:

@{formatdatetime(utcNow(),'yyyy-MM-ddT23:59:59')}

Or simply set it to pull for the following day using AddToTime():

@{addToTime(utcNow(),1,'day')}

Note that these expressions can be copy/pasted directly into your queries without using the Expressions editor. To use the Expression Editor, remove the at symbol and curly brackets.

Was this reply helpful? Yes No
FW-07051511-0 160 on at

Like
a
(2)

Report
Copy link

Link copied!

@Tomac

Your addToTime suggestion got me going in the right direction. Thank you.

Was this reply helpful? Yes No