Set Approval timeout to midnight

(0) Share

Report

Posted on by Ray_Garza

143

Hello Everyone,

I am trying to figure out how to set the timeout for a Start and Wait for Approval process to time out after 7-days at midnight (or 23:59:59 Hrs). I tried P7DT23:59 but that didn't work. Any ideas?

Many thanks,

Ray Garza

Categories:

General topics

All responses (6)

Answers (1)

Sort by

Verified answer

iltoningui 247 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Ray_Garza

The correct format would be P7DT23H59M59S.

Wich actually means 7 days 23 hours 59 minutes and 59 secs from the moment the actions was called.

You can't make timeout policy expire at midnight since it starts when the action starts and the policy expresses time span and not relative time.

The best you can do is to set P7D.

This way the flow will expire 7 days after the action is called.
Ray_Garza 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, @iltoningui for the clarification. I suspected as much but I wanted to be sure. I can now give users the exact time the notification will expire.
iltoningui 247 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ray_Garza

I was testing this scenario and I was able to set the timeout using value from the trigger

the @triggerBody()['text'] contains 'P1D'

Basically as long as you use values from the triggerBody/TriggerOutputs you should be able to set this property.

Let me know if you were able to do it.
Ray_Garza 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh really. Ok, how does this allow the end time to be midnight if it's still using the same duration notation?
iltoningui 247 on at

Like
a
(0)

Report
Copy link

Link copied!
Turns out you can use formulas.

@concat( 'P', '6D', 'T', sub(23, int(formatDateTime(utcNow(), 'HH'))), 'H', sub(59, int(formatDateTime(utcNow(), 'mm'))), 'M', sub(59, int(formatDateTime(utcNow(), 'ss'))), 'S' )

this will generate

if the time is 2022-03-24T20:04:10

this code will generate P6DT3H55M49S

Wich represents the time until midnight 6 days from now

Note that the code was prettified for readability it would actually be like this.

@concat('P', '6D', 'T', sub(23, int(formatDateTime(utcNow(), 'HH'))), 'H', sub(59, int(formatDateTime(utcNow(), 'mm'))), 'M', sub(59, int(formatDateTime(utcNow(), 'ss'))), 'S')

Good luck.
NewNW 204 on at

Like
a
(0)

Report
Copy link

Link copied!

@iltoningui Thank you very much for providing the formula. Can you please tell me how to use "AUS Eastern Standard Time" , currently when I use utcNow() it pickup US time so the WorkFlow won't expire at midnight AUS Eastern Standard Time.
Thank you very much.