Unanswered

get items filter on specific date

(0) Share

Report

Posted on by Dhiran

143

I have looked on the forum and most the of the get-items articles show searching by utcnow() but I want to search for a specific date.

In SharePoint list there is a field called Meeting Date (internal name: DiaryMeetingDate) and I have a 2 records in there with date set to 28/09/2023 and 25/10/2023.

I am trying to use get-items to filter using this query

DiaryMeetingDate eq '2023-09-28'

and it finds nothing. If i leave it blank, the record date shows up as

"DiaryMeetingDate": "2023-09-28",

Any ideas on why this doesnt work to search for a specifc date?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Hi @Dhiran
Is your SP column of type 'DateTime' and set as 'Date' only? Or is it of type 'Single line of text?
Since you SP list has just two items, my suggestion is the following:
Remove temporarily your ODATA filter
Add an 'Apply to each' assign as its input your 'Get items' 'value output
Inside your 'Apply to each' add a compose action block, and declare as its value the following WDL expression:

item()

Reexecute the flow and inspect Compose outputs in each iteration so you can verify 'Meeting Date' format values

Hope this helps
===========

Was this reply helpful? Yes No
Dhiran 143 on at

Like (0)

Report

Thanks for reply.

The date column is set to date only.

I did what you suggested and this was the output, so I am at a loss on why the filter doesnt work?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Dhiran

As part of trying different approaches , could you try this filter query instead ?

DiaryMeetingDate eq '9/28/2023'

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Dhiran 143 on at

Like (0)

Report

Hi @Nived_Nambiar I tried that and that doesnt work either. See my solution reply

Was this reply helpful? Yes No
Verified answer

Dhiran 143 on at

Like (2)

Report

The issue was that the list where I was searching on the dates had been modified with PowerApps to customise the form. The date field had been modified to show the date in the date picker as "dd mmm yyyy". Even though this was setup like this, the date in the list was still stored as "mm-dd-yyyy" as shown by the get items without any filter.

Its only after I removed this date format in the form and added a new record, it was working as expected. Thanks to all for replying but hard lesson learned!!

Dhiran

Was this reply helpful? Yes No