Get Items on sharepoint list where Modified is Today

(0) Share

Report

Posted on by dflemming

Hello, having difficulty getting today's modified items. My odata filter looks like this

modified error.png

The format of utcNow is yyyy-MM-dd but when I use eq or ge no results are returned. 'Less than' works and returns everything in the list that is 'Approved'. Could anyone suggest an easier way to do this?

Kind regards, Dale

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Jay-Encodian 2,920 on at

Like (0)

Report

Hey @dflemming

Try this expression: startOfDay(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')

Full filter query: Status eq 'Approved' and Created gt 'startOfDay(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')'

HTH

Jay

Was this reply helpful? Yes No
dflemming 85 on at

Like (0)

Report

Many thanks, I've made the change however my result is still empty. I've pasted my filter in below.

Status eq 'Approved' and Created gt '@{startOfDay(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')}'

When I check the list there are definitely items created today.

Regards, Dale

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report

Hey @dflemming

I have just setup this list to test the query:

SharePoint action configured as follows:

Filter query: Status eq 'Approved' and Created gt '@{startOfDay(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')}'

And the data returned is correct:

The JSON:

Can you please verify your query by breaking it down, i.e. just filter on status, and then just filter on the Created field... if there is an issue with status you need to verify the internal field name via list settings.

HTH

Jay

Was this reply helpful? Yes No
Verified answer

dflemming 85 on at

Like (0)

Report

Thanks Jay, I ran the date check alone and found some results. Then added the Approved condition after the date check and it worked. Thanks for the troubleshooting tip and the StartofDay() function. I know the order shouldn't affect it but I'm glad it working.

Was this reply helpful? Yes No