Unanswered

How to Format Date in the Sent Email?

(3) Share

Report

Posted on by BluFin.S

Hello guys,

For more than 2 hours I have been trying to solve a problem with my notification flow when rows are added to the List list.

The goal is to notify all members of that group, the flow works but I have a huge problem with the email formatting resulting with the horrible date.

These are the columns in the list with START (Inizio) and END (Fine) date

I know you can use variables but there is no way I can change the “start date” and “end date” of the event on List so that it is readable.

The email

Can you help me to do this? I would like to see date as dd/MM/yyyy hh:mm

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (3)

Report

Hi there,

I see you're initializing your variable however you haven't pointed it at the Start Date which is shown in the Dynamic Content from your trigger action.

You need to apply your formatting to that.

Here's an example:

formatdatetime(triggerOutputs()?['body/DataeOraInizio'],'dd-MMM-yyyy')

Then, you'd use that variable in your email body.

Was this reply helpful? Yes No
BluFin.S 56 on at

Like (1)

Report

Thank you for your time @Rhiassuring but i got this error:

Was this reply helpful? Yes No
BluFin.S 56 on at

Like (1)

Report

Update

I have tweaked a but the code and now IT WORKS! Awesome

Just one last detail.
How can I format the date as 07/09/2024 instead of using the name of the month in English i.e. SEPTEMBER?
To add the same formatting to the second date, do I add another variable?

Thank you very much

Was this reply helpful? Yes No
BluFin.S 56 on at

Like (1)

Report
One last issue..ho do i add the time zone coversion from UTC to CET (UTC +1) in this string? @Reassuring

formatdatetime(triggerOutputs()?['body/DataeOraFine'],'dd-MMM-yyyy hh:mm')

Was this reply helpful? Yes No
Verified answer

BluFin.S 56 on at

Like (1)

Report
I have found the solution, here you are

formatDateTime(convertTimeZone(triggerOutputs()?['body/DataeOraFine'], 'UTC', 'Central European Standard Time'), 'dd-MM-yyyy HH:mm')

Was this reply helpful? Yes No