Get Items filter by DATE AND TIME

(0) Share

Report

Posted on by livingstonep

358

Hi,

I am trying to build an ODATA Filter Query that will restrict the resukts from the list to all items that have the Status field = Approved and the Modified date = Today, but AFTER 4PM

so how can I do that?

here's what I've got, but it isn't working:

Status eq 'Requested' and Modified gt @{formatDateTime(utcNow(),'yyyy-MM-dd 16:00:00')}

how can I filter by Date and time please

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

I would try the following

https://powerusers.microsoft.com/t5/Building-Flows/ODATA-Filter-for-SharePoint-Date-Time-field-issues/td-p/256964

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @livingstonep ,

If the type of Status column is choice, we could not configure it in Filter Query.

Besides, we need to add a single quote outside the expression.

Image reference:

Expression reference:

formatDateTime(utcNow(),'yyyy-MM-ddT16:00:00Z')

If the type of Status in choice, please try to use Filter array to filter items and you need to fill Status Value in the filter.

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
livingstonep 358 on at

Like (0)

Report
Copy link

Link copied!

thanks, in fact the Status filter is already working fine - it's the filter finding only items that were approved after 4PM Today that is giving trouble

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @livingstonep ,

Thank you for your reply. So is the method in my previous reply helpful to you?

Best Regards,

Was this reply helpful? Yes No
Chloe2021 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, could you please help me as i have met the similar problem like the livingstonep, but i have set the two filter condition one is Modified gt 'addDays(utcNow(),-90,'yyyy-MM-ddTHH:mm:ssZ') and another Displayname2 ne 'null' and the test warning failure.

But I test two conditions separately, it succeeded.
i am quite confused, could you help to solve this problem?

Was this reply helpful? Yes No