Delay Until

[mtagliaferri]

I have a flow that is paused until a specific date in a SharePoint column, the date in SP is in the format dd/mm/yyyy; in order to the Delay Until step to work I had to set a variable to format the date to yyyy-MM-dd.

The flow works and is triggered by the input at 12:00 Midday.

How do I get to change the time to midnigh Z 00:00Z? So that the flow is triggered at that time instead of 12:00Z

The code below is the formatted dated:

formatDateTime(triggerOutputs()?['body/Date_x0020_Effective_x0020_From'],'yyyy-MM-ddThh:mm:ssZ')

[v-yiwenxie-msft]

Hi @mtagliaferri 

I guess if the input is made at 1/8/2021 12:00 midday, and the timestamp input in the ‘delay until’ action you want is 1/9/2021 00:00 midnight. Am I right?

You do not need to set variable. Just put an expression in the timestamp as below.

addDays(startOfDay(formatDateTime(triggerOutputs()?['headers/date'],'yyyy-MM-ddThh:mm:ssZ')),1)

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

[mtagliaferri]

Hi, thanks but I am still confused, the Date Effective From is a column set to date only in the SharePoint library, the user enters a plane date in the format dd/mm/yyyy at some stage (Whether when the item is created or modified later).

I converted the dd/mm/yyyy to the format yyyy-MM-dd in order to for the Delay Until to work, every entry made to the Date Effective From, no matter what time this has been entered, will pick up 12:00Z.

I don't need to add 1 day to the value as I need the flow to trigger on that specific day. e.g. if the day entered is 09/02/2021 I need this to trigger at midnight of the 8th into the 9th.

[mtagliaferri · Accepted solution]

I might have cracked it! I am just testing it so see the outcome!

I have change the Format Date code to 00:00:00Z instead of hh:mm:ssZ:

formatDateTime(triggerOutputs()?['body/Date_x0020_Effective_x0020_From'],'yyyy-MM-ddT00:00:00Z')

[v-yiwenxie-msft]

Hi @mtagliaferri 

So glad that you have solved the problem yourself!

You can accept it as an solution for other members to find it more quickly.

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

[MWibisono]

How can I use extracted date and time from email body and format it using formatdatetime converting from output compose {for example: 4-12-2023 13:31 (dd-MM-yyyy HH:mm)} into yyyy-MM-ddTHH:mm:ssZ?

Reference:

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-date-from-email-body/td-p/2311504

[gomezjr]

TLDR: Dont fight UTC timezone. I added the two formulas to the notes for anyone that has to come behind me to support.

I used:

addDays(utcNow(),7)

This delays until 7 days from the minute/second the autmation is run.​ In my case the automation itself is scheduled @7pm CST.

Because, "The 'timestamp' value of the 'Wait' action 'until' inputs must be specified in UTC using the round-trip date/time pattern (for example, '2015-10-22T10:00:00Z'), " getting the UTC time an just adding X number of days or munites works, but i no likey....

Any attempt to convert to another zone resulted in the Delay Until triggering, in my case, 5 hours ahead of my CST schedule. This made testing super confusing, until i decided to sacrifice OCD adherance to MY timezone.

To test i used:

addDays(addMinutes(utcNow(), 5, 'yyyy-MM-ddTHH:mm:ssZ'),0)

This added 5 mintes and 0 days. Works.

I consider this a convoluted way to test the flow and delay until 5 min, but it works....If anyone has insight how i can accomplish immediate testing with simpler approach, please advise.

[MWibisono]

How to convert only date to yyyy-MM-ddT00:00:00Z? 

Thank you