Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Today minus 2 years - condition not working

I have a flow where I wish to check the value of a date column and if thats equal to 730 days ago, then send an email. 


When this is working we will be using the "Created" date column however for testing, I have a column named "Created1".


I have set the date to the 3rd March 2020 (UK format) as above which is 730 days ago.

However when the flow is run, the condition checks the "Created1" field but does not send an email.





Resolver II
Resolver II


I think you also need to formatDateTime your Sharepoint column in the filter (left side as well) to match the format? And maybe play around with greater than or less than to see if the filter condition can be met.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,866)