The datetime string must match ISO 8601 format.

(0) Share

Report

Posted on by CopeStarr

Hi,

I'm getting the following error on my flow when sending an email:

Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

It started today, but it has been working so I'm a bit confused.

formatDateTime(variables('DateofCall'),'dd-MM-yyyy')

There is another date variable in the flow with same issue - DateOfFollowUp

It was all working on Friday, which is why I'm scratching my head - successful flow below and email was received with correct date format

Thanks for any help offered.

Darren.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

David- 1,254 on at

Like (0)

Report

Please show what is being returned in the Set variable DateofCall action. I suspect that it is not setting the date as 'yyyy-MM-dd' which is the ISO 8601 format that is expected in the expression in your Send e-mail action. If you are already formatting this date how you need it in the Set variable action, you can just use the variable in your e-mail instead of doing a formatDateTime expression on the variable.

Was this reply helpful? Yes No
CopeStarr 48 on at

Like (0)

Report

Hi David,
Thanks for the reply - appreciate it.

I think this is what you asked for:

Regards your 2nd statement about not using the expression, I'm sure I've probably made this long-winded in my approach. I haven't set any exact data parameters anywhere else, which is why I assumed I had to do it via an expression? I'm learning on the job so not an expert by any stretch 🙂

Thanks.

Was this reply helpful? Yes No
David- 1,254 on at

Like (0)

Report

That date format is correct, so it should have worked. I am stumped.

Was this reply helpful? Yes No
CopeStarr 48 on at

Like (0)

Report

Thanks for looking, David - The fact it was working and nothing has changed has me stumped too...

Edit - Just gone back in and flows are now working again - I wonder if there is an issue at MS end - will have a look around...

Was this reply helpful? Yes No