Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 7btFhIcYASXcdOcfRElaRI
Power Automate - Building Flows
Answered

get items filter on specific date

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2023 16:24:31 by 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?

  • Verified answer
    Dhiran Profile Picture
    143 on 25 Sep 2023 at 06:55:07
    Re: get items filter on specific date

    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

  • Dhiran Profile Picture
    143 on 25 Sep 2023 at 06:50:33
    Re: get items filter on specific date

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

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 24 Sep 2023 at 12:23:36
    Re: get items filter on specific date

    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 Profile Picture
    143 on 24 Sep 2023 at 11:56:30
    Re: get items filter on specific date

    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?

     

     

    Dhiran_0-1695556573392.png

     

  • efialttes Profile Picture
    14,756 on 22 Sep 2023 at 17:22:25
    Re: get items filter on specific date

    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

    efialttes_0-1695403327200.png

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 55

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 39 Super User 2025 Season 1

#3
VictorIvanidze Profile Picture

VictorIvanidze 26

Overall leaderboard