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!
Hey, that did the trick! Thank you so much! 😄
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
It is a datetime column
Is the sharepoint column a datetime column or just text?
Michael E. Gernaey
66
Super User 2025 Season 1
stampcoin
65
rzaneti
39
Super User 2025 Season 1