Answered

Formating date in an email dynamic content?

(0) Share

Report

Posted on by Igerarts

Hello,

here is my problem, how to change the format of a date in the "Start Time" & "End Time" dynamic content added to an email?

This so that the format is correctly readable by the person who receives the mail?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Igerarts you can use below expression to format date and time. Use this expression in the Dynamic content -> Expressions. Replace <Start Time> by selecting the Start Time value from Dynamic Content in the expression.
formatDateTime(<Start Time>, 'M/dd/yyyy h:mm tt')

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report
Copy link

Link copied!
@annajhaveri thanx for help,

tried this
formatDateTime(items('Appliquer_à_chacun')?['start/Date'],'dd/MM/yyyy')

but return me an error

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Igerarts can you please share what error are you facing?

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report
Copy link

Link copied!
So no error in the expression for the 2 expressions

formatDateTime(items('Appliquer_à_chacun')?['start/Date'],'dd/MM/yyyy') formatDateTime(items('Appliquer_à_chacun')?['end/Date'],'dd/MM/yyyy')

but after testing got

ActionBranchingConditionNotSatisfied. The execution of template action 'Envoyer_un_e-mail_à_partir_d’une_boîte_aux_lettres_partagée_(V2)_2' skipped: the branching condition for this action is not satisfied.

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report
Copy link

Link copied!

beforeafter

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Igerarts not able to see exact error, do you see any errors on right side of the flow run screen?

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report
Copy link

Link copied!
Here's it

InvalidTemplate. Unable to process template language expressions in action 'Envoyer_un_e-mail_à_partir_d’une_boîte_aux_lettres_partagée_(V2)_2' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Was this reply helpful? Yes No
Verified answer

Igerarts 40 on at

Like (1)

Report
Copy link

Link copied!
@annajhaveri

found it

formatDateTime(items('Appliquer_à_chacun')?['start'],'dd/MM/yyyy')

I have specified start/date when it failed, try just with start (as the original value for 'items') and it work.

ths for time and help

Was this reply helpful? Yes No