Answered

Delay until - action not working

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

LeeHarris 1,026 on at

Like (0)

Report
Copy link

Link copied!

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#date-and-time-functions

A good introduction to using expressions can be found here:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Microsoft-Flow-Expressions-and-how-to-use-them/ba-p/92405

Was this reply helpful? Yes No
PMac 84 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

LeeHarris 1,026 on at

Like (9)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PMac 84 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cmoautomate 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ncotela23 101 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No