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
Solved! Go to 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
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
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:
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
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 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
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
@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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
24 | |
20 | |
9 | |
8 | |
7 |
User | Count |
---|---|
39 | |
30 | |
26 | |
23 | |
13 |