get items filter on specific date

[Dhiran]

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?

[efialttes]

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
===========

[Dhiran]

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?

[Nived_Nambiar]

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! 🙌

[Dhiran]

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

[Dhiran · Accepted solution]

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