Microsoft Flow – Compare dates using conditions in the SharePoint connector

Microsoft Flow 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.

I started by creating a Condition following the Manually trigger a flow trigger. I can now select the is greater than operation.

Compare Dates from a Manually trigger a flow trigger

No problem there.

Now I’m doing the same with a trigger in the SharePoint connector.

Comparing dates from a SharePoint trigger don't show all comparison operations

Hmm, there are very limited options there.

The solution is easy. (Thank you Serge Luca for the idea!)

ticks function on triggerBody

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.

 

 

 

 

 

 

Advertisements


Categories:Flow, Microsoft Flow, Office 365, SharePoint Online

Tags: ,

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: