Power Automate - format of date within body email

Like (0) Share

Report

Posted on 9 Sep 2021 01:50:31 by Violet1

Hi,

i have created a flow using power automate (with the assistance of eric-cheng), that will send an email to a user 30 days prior to a due date. The emails are working fine; subject line and content in body is good, however the date in the body is in the wrong format.
- Currently the format is MM-dd-yyyy and i would like to change it to dd-MM-yyy. Following is what i tried
- I changed the format at the 'Initalize variable' stage
from: addDays(utcNow(), variables('varNumDays'), 'MM-dd-yyyy')
To: addDays(utcNow(), variables('varNumDays'), 'dd-MM-yyyy'). when i did this the emails did not send.
- I then added a Compose to the the 'Apply to each'. Email worked but date in wrong format

Any help will be greatly appreciate

Thank you

Screen 1.png Screen 2.JPG Screen 3.JPG

All responses (3)

Answers (0)

Violet1 31 on 14 Sep 2021 at 04:50:15

Like (0)

Report

Re: Power Automate - format of date within body email

Hi eric,
added new format date string and now the flow is coming up with an error 'String was not recognized as a valid DateTime. Creating query failed.'
Violet1 31 on 10 Sep 2021 at 04:09:11

Like (0)

Report

Re: Power Automate - format of date within body email

Hi eric,

tried formatDateTime(addDays(utcNow(), variables('varNumDays')),'dd-MM-yyyy') however the date is still displayed as yyyy-mm-dd
eric-cheng 5,171 on 09 Sep 2021 at 06:54:08

Like (0)

Report

Re: Power Automate - format of date within body email

Hi @Violet1 ,,

Try

formatDateTime(addDays(utcNow(), variables('varNumDays')),'dd-MM-yyyy')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn