Send an email v2 Format the date as dd-MM-yyyy

(0) Share

Report

Posted on by AdamInLondon

125

I have a Flow using Send an email v2 when a new item is created in a SharePoint list

The SharePoint list has a Date field in it and I want that date to be part of the email.

It works but the Date field shows in the email as for example 2021-05-27

But I want it to display in the UK/European format of 27-05-2021

I know I need to use the Expression to do this with FormatDateTime but how do I "wrap" that around the date field?

Date Format.JPG

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, you can just remove the date from your subject, and add it back in using the expression editor, with the expression:

formatDateTime(outputs('Date'), 'dd-MM-yyyy')

But instead of outputs('Date') you will select your date from your dynamic content. Does that make sense?

Was this reply helpful? Yes No
AdamInLondon 125 on at

Like (0)

Report
Copy link

Link copied!

Hi thanks for this
Thanks it starts to make sense but
it formats it like this:
formatDateTime(ouputs(triggerOutputs()?['body/Date']))

where do I specify I want dd-MM-yyyy ?

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
Use this expression:

formatDateTime(ouputs(triggerOutputs()?['body/Date']), 'dd-MM-yyyy')

Was this reply helpful? Yes No
AdamInLondon 125 on at

Like (0)

Report
Copy link

Link copied!

Hi Im getting this error:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'Template language expression cannot be evaluated: the default fired trigger is not defined at current scope. '.'.

This is the expression copied directly from my flow:

formatDateTime(outputs(triggerOutputs()?['body/Date']),'dd-MM-yyyy')

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (2)

Report
Copy link

Link copied!
Sorry, my error:

formatDateTime(triggerOutputs()?['body/Date'], 'dd-MM-yyyy')

1 people found this reply helpful.

Was this reply helpful? Yes No
AdamInLondon 125 on at

Like (0)

Report
Copy link

Link copied!

Perfect! That works, thank you so much!

Was this reply helpful? Yes No
AdamInLondon 125 on at

Like (2)

Report
Copy link

Link copied!

This is how it looks now working:

Was this reply helpful? Yes No