cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Wilmslow1
Level: Power Up

"2019-04-18T11:34:14.9391304Z" Not working with delay until

Hello All,

 

I have connected to a an excel online table, with a date column formatted as 

"2019-04-18T11:34:14.9391304Z".
 
When I run the flow, the delay untill action stops at this point and clocks up hours of time, i.e it times out and doesnt move onto the next step.
 
However when I enter a date in the same format but not in the future (i.e a past date), it moves onto the next steps just fine which obvioulsy negates the point of having a "delay untill" action anyway.
 
I am in the UK, my time settings are all set to the UK.
 
Can anyone help me wth this?
1 REPLY 1
SamPo
Level 8

Re: "2019-04-18T11:34:14.9391304Z" Not working with delay until

@Wilmslow1 In this date format, all times are set to UTC+0 and flow by default uses UTC+0 regardless of your timezone. You can use the 'convert time' action to convert your time to UTC+0 before using it in the 'delay until' action.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 209 members 5,489 guests
Please welcome our newest community members: