Determining number of minutes since last flow run

[Charles-v-D]

Hello all,

I have a flow (pre-check) that my staff needs to run to determine if all parameters have been set correctly etc. After this they launch the actual approval flow. I want to check if the time between completing flow 1 and starting flow 2 is not exceeding my guidelines of 10 minutes.

when completing flow 1 I write the UTCNOW() into the field FLOW1COMPLETE (type date/time). 

when starting flow 2 I want to check if UTCNOW() minus FLOW1COMPLETE > 15 minutes.

I tried to calculate ticks from both and then substract these, but the outcome (in nanoseconds) does not make sence....

Can anyone please point me in the right direction how to substrate two date/time fields to obtain "time passed"?

Thanks

Regards

charles

[v-lin-msft · Accepted solution]

Hi @Charles-v-D,

You could write the addMinutes(utcNow(),15) into the a field "CompletedIn15Minutes" when completing flow1;

When staring flow 2 chick if UtcNow() is greater than "CompletedIn15Minutes".

Please have a try, hopes it can help you.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Charles-v-D]

@v-lin-msft 

PERFECT

Thanks

Regards

Charles