Get the difference between two date or datetime values in Power Automate

November 9th 2023

Post #16 of our Build Flows Faster series covering our new utility actions for Power Automate. We will publish many more posts and accompanying videos over the coming weeks, but today’s lesson is about generating and determining the difference between two date or datetime values in Power Automate.

Our utility actions are targeted at helping you build flows more quickly with less complexity, and they brilliantly only use 0.05 actions from your Encodian Flowr and Vertr subscription allowance. For example, under a standard plan that permits 500 actions per month (uses), you could use the utility actions 10,000 times!

Introducing the ‘Get Date and Time Difference’ Utility Action

Our ‘Get Date and Time Difference‘ utility action for Power Automate calculates the difference between the two date (and time) values provided.

Video Guide: Calculate date and time differences in Power Automate

Instructions: Calculate date and time differences in Power Automate

As with many of our utility actions, there are a myriad of scenarios where you may need to calculate the differences between two date and time values. Therefore, we’ll focus on how the ‘Get Date and Time Difference‘ utility action works instead of focusing on a specific scenario.

The Trigger

Firstly, consider the following basic and manually triggered flow:

Get the Date and Time difference

After setting your trigger, let’s configure the flow to calculate the difference between the date values provided and send the result back within an email.

1. Add the ‘Get Date and Time Difference‘ utility action

1.a Start Date: Select the ‘Start Date’ property provided by the trigger action

1.b. End Date: Select the ‘End Date’ property provided by the trigger action

1.c. Interval: Select and interval

Send an email

2. Add the ‘Send me an email notification‘ action

2.a. Subject: Configure the email subject value as required

2.b. Body: Configure the email body as required, including the ‘Result‘ property provided by the ‘Get Date and Time Difference‘ utility action

Upon execution, the following email will be generated:

Please email our support team if you require further advice or support regarding Encodian utility actions. You can do so at support@encodian.com; the team would be delighted to help.

Author
Jay Goodison

Managing Director

You might also be interested in...