You’re offline. This is a read only version of the page.
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 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.
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
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
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:
A good introduction to using expressions can be found here:
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
