Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

ODATA Filter Query on Date

Like (1) ShareShare
ReportReport
Posted on 18 Mar 2022 11:04:17 by 19

I was trying to use the Get Items actions and filter a certain date, and check if that date is equal to todays date. Now I have been looking online and found that this should be the solution:

NoTimeLeft_0-1647601332384.png

However, doing this results in the following error:

NoTimeLeft_1-1647601376731.png

Here is the format on how the date is currently shown in SharePoint as well:

NoTimeLeft_2-1647601422753.png

What am I doing wrong?

 

Thanks!

 

  • NoTimeLeft Profile Picture
    19 on 18 Mar 2022 at 12:26:26
    Re: ODATA Filter Query on Date

    Hey, that did the trick! Thank you so much! 😄

  • Verified answer
    KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 12:08:03
    Re: ODATA Filter Query on Date

    SharePoint is being funny, it is displaying the date in the sharepoint column in one format, but secretely hiding the date in a different format. 

    The flow needs the format that sharepoint uses to save it, not the one you see

    A good way to figure this out is to run the action without the filter, then check the output to see what the flow actually gets as input. You should filter on that input, not on what is beind displayed to you in SharePoint.

     

    This, for example, is also the case when you would change the name of a column in sharepoint (automate will continue to use the old name, for better or for worse)

     

    To sum it up, you should filter on 

    KvB1_0-1647605262764.png

    because that is the date format that the flow is receiving from the action

     

  • NoTimeLeft Profile Picture
    19 on 18 Mar 2022 at 11:37:18
    Re: ODATA Filter Query on Date

    It is a datetime column

    NoTimeLeft_0-1647603430548.png

     

  • KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 11:09:51
    Re: ODATA Filter Query on Date

    Is the sharepoint column a datetime column or just text?

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 65

#3
rzaneti Profile Picture

rzaneti 39 Super User 2025 Season 1

Overall leaderboard
Loading started