Answered

How to Format Date in the Sent Email?

Like (3) Share

Report

Posted on 3 Sep 2024 22:00:03 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:

Process Advisor

All responses (5)

Answers (1)

Verified answer

BluFin.S 56 on 12 Sep 2024 at 23:56:56

Like (1)

Report
How to Format Date in the Sent Email?

I have found the solution, here you are

formatDateTime(convertTimeZone(triggerOutputs()?['body/DataeOraFine'], 'UTC', 'Central European Standard Time'), 'dd-MM-yyyy HH:mm')
BluFin.S 56 on 05 Sep 2024 at 01:35:34

Like (1)

Report
How to Format Date in the Sent Email?

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')
BluFin.S 56 on 04 Sep 2024 at 23:15:51

Like (1)

Report

How to Format Date in the Sent Email?

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 04 Sep 2024 at 23:02:14

Like (1)

Report

How to Format Date in the Sent Email?

Thank you for your time @Rhiassuring but i got this error:
Rhiassuring 8,688 Super User 2025 Season 1 on 04 Sep 2024 at 05:52:34

Like (3)

Report

How to Format Date in the Sent Email?

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.