cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NoTimeLeft
Regular Visitor

ODATA Filter Query on Date

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
KvB1
Solution Sage
Solution Sage

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

 

View solution in original post

4 REPLIES 4
KvB1
Solution Sage
Solution Sage

Is the sharepoint column a datetime column or just text?

It is a datetime column

NoTimeLeft_0-1647603430548.png

 

KvB1
Solution Sage
Solution Sage

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

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,769)