Answered

Comparison between two dates

(0) Share

Report

Posted on by Yuyu33

Hi everyone,

I have a flow that allows me to retrieve data from sharepoint, filter it and the goal is to receive an email at the end of the filters.

My date format looks like this after my 1st filter: "Date_de_modification": "2023-09-08T10:16:55Z". And I'd like to compare that date to today's. If it's equal then filter ok. I don't know if I should use comparison or filter. What do you think is the easiest method? I tried filtering with UTCnow but without success.

Thank you for your help 🙏.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

MrGott 101 on at

Like (2)

Report
Copy link

Link copied!

when filtering SharePoint, try using the Odata filter expressions, as it will be more efficient
the filter expression should read something like:

Date_de_modification gt @{formatDateTime(utcNow(),'yyy-MM-dd'))}

Was this reply helpful? Yes No
Yuyu33 26 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your feedback, i try this option by replace the right expression (because Date_de_modification come from after a select) but it's doesn't work, how can i can do a filtrer after another filter ? Do i have to convert the format ? Pleased find the flow bellow :

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Yuyu33

In the filter array expression - you have to convert the dates on both sides of comparision to single format - let's say yyyy-MM-dd for this case.

so expression would be

Left side > formatDateTime(item()?['Date_de_modification'],'yyyy-MM-dd')

Right side > formatDateTime(utcNow(),'yyyy-MM-dd')

Another easy approach would be as suggested by @AndiM using Odata Filter query

You can use Odata filter query and then you can use select action with whichever details/columns you need , that would be more efficient.

Filter query Odata should be like this -

(Modified ge '@{formatDateTime(utcNow(),'yyyy-MM-dd')}') and (Modified le '@{addMinutes(addDays(formatDateTime(utcNow(),'yyyy-MM-dd'),1),-1)}')

What i understood is Modifed column is your Date_de_modification column , so why don't do a filter first with odata using modified date and then do a further select actions ?

Try this and let me know 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Yuyu33 26 on at

Like (0)

Report
Copy link

Link copied!

Hello @Nived_Nambiar

Thanks for your feedback, i try your solution (use Odata filter query) it's work well (i just change the number of minute for my purpose but it's work. Thanks again 😁.

Was this reply helpful? Yes No