Answered

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

All responses (5)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!

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.
BluFin.S 56 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your time @Rhiassuring but i got this error:
BluFin.S 56 on at

Like
a
(1)

Report
Copy link

Link copied!

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
BluFin.S 56 on at

Like
a
(1)

Report
Copy link

Link copied!
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')
Suggested answer

BluFin.S 56 on at

Like
a
(1)

Report
Copy link

Link copied!
I have found the solution, here you are

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