Unanswered

ODATA Filter Query on Date

(1) Share

Report

Posted on by NoTimeLeft

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:

However, doing this results in the following error:

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

What am I doing wrong?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

KvB1 1,596 on at

Like (1)

Report

Is the sharepoint column a datetime column or just text?

Was this reply helpful? Yes No
NoTimeLeft 19 on at

Like (0)

Report

It is a datetime column

Was this reply helpful? Yes No
Verified answer

KvB1 1,596 on at

Like (5)

Report

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
because that is the date format that the flow is receiving from the action

Was this reply helpful? Yes No
NoTimeLeft 19 on at

Like (1)

Report

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

Was this reply helpful? Yes No