Unanswered

Filter sharepoint List comparing a field date with today date in ODATA filter

(0) Share

Report

Posted on by TheGallons

Hi all,
I wrote a flow that filters a sharepoint list by comparing a field called DataMemoEmbargo with today's date.
For each record found, it sends an email to an email contact.
I seem to have done everything correctly but the flow does not extract any records.
I tried changing the filter, using another text field, and everything works.
When I use the DataMemoEmbargo field, it does not extract anything.
Attached to this post is the sharepoint record with the date field visible, and the stream I use.
I thank you for any suggestions on this matter
Davide

Categories:

Building flows

Flow.png

Record Sharepoint...

I have the same question (0)

All responses (6)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@TheGallons If you review the Filter Query outputs from the Get Items action, I would imagine that the date isn't outputting what you expect.

In your expression you are using UTC. Depending on when you run this flow, the date will adjust to UTC.

Convert Time Zone
Whenever using dates and times in your flow it's always good practice to use a Convert Time Zone action.

Count Items Returned
I would also recommend adding a Compose action after the Get Item action to count the number of items returned.

Use an expression and the length() function with the value outputs from the Get Items action. This can help with troubleshooting and also can be used in a Condition action.

Add a Condition
Add a Condition to your flow to continue with additional actions if items have been returned.
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
TheGallons 89 on at

Like (0)

Report

Hello,
thank you for your response.
I modified the flow by inserting all the suggested sections.
The strange thing is that the first time it worked, then it didn't work anymore.
I noticed that the section related to time zone conversion, has one more field than what you suggested in your post.
The flow gives no errors but it does not select any records for me.
I give you below the flow and the output it returns.
I noticed that in the conversion output it returns me a date in an incorrect format (mm/dd/yyyyy) even though I put the correct time zone.
Is there something I am doing wrong?

Input
Output

In the meantime I look into your youtube channel.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@TheGallons Can you confirm what value is stored in the DateMemoEmbargo column? Is it just a date? Or does it also store the time?

Was this reply helpful? Yes No
TheGallons 89 on at

Like (0)

Report

In sharepoint list there are more than 5000 records.
All records has no value in DataMemoEmbargo
Just one record has DataMemoEmbargo = 27/10/2023.
It is a Date field, without Time.
I use that record for test and I change the value and set it to today date before run the flow.

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@TheGallons If you didn't turn on pagination and set a threshold through the settings of the Get Items action—that action will only return 1000 records by default.

By turning on Pagination, the flow will retrieve your items in batches. The number you set in the threshold would be the number of items retrieved per call. You will need to adjust this number based on your requirements and how the flow performs. It'll all depend on the amount of data you are receiving, your account limitations etc.

It may be a better idea to use a smaller threshold and have more calls or a larger threshold. I believe the max threshold is 5000.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
TheGallons 89 on at

Like (0)

Report

Hi,
thanks for the advice.
I set 5000 as the value for pagination and now it works. I don't have any performance issues because it is a flow that is automatically scheduled early in the morning to send to users a reminder to unlock their products.
I thank you so much for the invaluable support and have a good day.
Thank you
Davide

Was this reply helpful? Yes No