When you compare dates in Power Automate conditions, you will quickly hit some difficulties.

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.

Share this:



Tweet

WhatsApp

Email





Like this: Like Loading...