Answered

ODATA Filter Query on Date

Like (1) Share

Report

Posted on 18 Mar 2022 11:04:17 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!

All responses (4)

Answers (1)

NoTimeLeft 19 on 18 Mar 2022 at 12:26:26

Like (1)

Report

Re: ODATA Filter Query on Date

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

KvB1 1,596 on 18 Mar 2022 at 12:08:03

Like (5)

Report

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
because that is the date format that the flow is receiving from the action
NoTimeLeft 19 on 18 Mar 2022 at 11:37:18

Like (0)

Report

Re: ODATA Filter Query on Date

It is a datetime column
KvB1 1,596 on 18 Mar 2022 at 11:09:51

Like (1)

Report

Re: ODATA Filter Query on Date

Is the sharepoint column a datetime column or just text?