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

Like (0) Share

Report

Posted on 26 May 2021 11:18:30 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

I have the same question (0)

All responses (7)

Answers (1)

AdamInLondon 125 on 26 May 2021 at 12:57:03

Like (2)

Report

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

This is how it looks now working:

Was this reply helpful? Yes No
AdamInLondon 125 on 26 May 2021 at 12:41:20

Like (0)

Report

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

Perfect! That works, thank you so much!

Was this reply helpful? Yes No
Verified answer

Paulie78 8,416 Moderator on 26 May 2021 at 12:38:29

Like (2)

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

Sorry, my error:

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

Was this reply helpful? Yes No
AdamInLondon 125 on 26 May 2021 at 12:33:49

Like (0)

Report

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

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
Paulie78 8,416 Moderator on 26 May 2021 at 11:39:48

Like (0)

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

Use this expression:

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

Was this reply helpful? Yes No
AdamInLondon 125 on 26 May 2021 at 11:34:13

Like (0)

Report

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

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,416 Moderator on 26 May 2021 at 11:24:25

Like (0)

Report

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

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