cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Time calculation

Hi,

 

I have a condition in my Flow like:time_calculation.PNG

Time out is always a full hour because user select it and it looks like 12/09/2019 15:00 and the Timestamp is the real time of Checking out 12/09/2019 14:56:31.

In this example, an email would be sent because 12/09/2019 15:00 is greater than 12/09/2019 14:56:31 and it means that the employee checked out before 15:00. However, employees are allowed to check out 5 minutes earlier.

My question is how to build this condition so 12/09/2019 15:00 (- 5 minutes) > 12/09/2019 14:56:31 and the condition will be false so email will not be sent.

 

Thank you.

 

Slawek

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Time calculation

@TheSlawekG 

You'll need to use an expression in your condition - see my example below.

The expression that I used can be seen in the comments area.

I selected Time Out from Dynamic properties while creating the expression - your reference to the time out column may/may not look a little different than mine.

Timestamp.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Time calculation

@TheSlawekG 

You'll need to use an expression in your condition - see my example below.

The expression that I used can be seen in the comments area.

I selected Time Out from Dynamic properties while creating the expression - your reference to the time out column may/may not look a little different than mine.

Timestamp.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Community Support
Community Support

Re: Time calculation

Hi @TheSlawekG ,

 

Have your problem been solved?

Please refer to screenshot below to create the flow:

1.png

 

And the expression in the Condition as below:

addMinutes(outputs('Compose'),-5)

Please let me know if your problem could be solved.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper I
Helper I

Re: Time calculation

@ScottShearer thank you!

 

@v-alzhan-msft I didn't try your approach as @ScottShearer one works fine.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,201)