Delay until - action not working

[PMac]

I have a survey set up informs and want to delay an email (within flow) based on the 'effective date' entered in the survey (using forms date format).  I'm using a link from dynamic content, however I keep getting an this error message:

BadRequest. 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'). For details please review the Standard Date and Time Format Strings of the .Net framework.

I get that it's a formatting issue but how do I change the format of a dynamic content link?  Thanks

[LeeHarris]

Hi @PMac

You can make use of expressions within Flow to format your Dynamic Content how you need it.

A full list of DateTime functions can be found here:

https://docs.microsoft.com/en-gb/azure/logic-apps/workflow-definition-language-functions-reference#d...

A good introduction to using expressions can be found here:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Microsoft-Flow-Expressions-and-how...

[PMac]

This is really helpful, unfortunately I'm obviously missing something as the expression I've used isn't working.  Where do you put the dynamic content in?  I tried following your instructions faithfully, with the dynamic content in orange, but it wouldn't accept it so ended up with  

formatDateTime(body('get_response_details')?['r50efee1c8f4c4989bef86073c2d41dd6'],)

And still getting the BadRequest error.  Thank you in advance!

[LeeHarris · Accepted solution]

Hi @PMac

You also need to include the format that you want your date to be in as the second parameter of the FormatDateTime function.

As an example:

formatDateTime(body('get_response_details')?['r50efee1c8f4c4989bef86073c2d41dd6'],'yyyy-MM-ddThh:mm:ssZ' ) 

will output the date as something like 2019-01-30T16:03:00Z. Your Dynamic Content is the first parameter in orange and the format is the second parameter in green.

More information on ISO date formats can be found here https://en.wikipedia.org/wiki/ISO_8601

[PMac]

@LeeHarris Brilliant - so excited this worked.  thank you!!!!

[cmoautomate]

Is it possible to use this feature to delay for a weekly posting?

[ncotela23]

@LeeHarris when I enter this formula, it works partly. I say partly because it creates a task on the date I input, but it does not complete the update task details step within the flow. It looks as though it skips right over it.