When you compare dates in Power Automate conditions, you will quickly hit some difficulties.
Implementing conditional logic
Power Automate is great to create your business processes. Using conditions, you can move into different parts of your process depending on data that is found by your flow. All easy, but then you start looking at comparing dates and quite quickly you will hit some troubles.
Conditions in Power Automate
I started by creating a Condition following the Manually trigger a flow trigger. I can now select the is greater than operation.
No problem there.
Compare dates in Power Automate
Now I’m doing the same with a trigger in the SharePoint connector.
Hmm, there are very limited options there.
Compare dates with ticks function
The solution is easy. (Thank you Serge Luca for the idea!)
Now I just have to do add the ticks function to both sides of the condition. Suddenly all the comparison options appear. And now I can use all the options that I may need for date comparisons as the ticks function turns the dates into a number representing the date.
Thanks for this! I was having a nightmare with dates from a Sharepoint list and using a condition, was getting all sorts of strange results but using the tick function fixed it.
Fantastic! Ticks works like a charm!