Email from Flow shows incorrect date format (Forms Date Picker)

[Masor]

When building flow from a Microsoft Form with a datepickerfield, I want to e-mail the selected date.

In Form I see format; 11-12-2018, but in Flow  generated e-mail is format:  2018-12-11

How can I format a dynamic Form field form Forms in Flow in 'sending a e-mail?

In Forms  mij  input date is called;  "Datumkeuze"

[Pieter_Veenstra]

HI @Masor,

Is this formatDateTime function what you are looking for?

https://veenstra.me.uk/2018/11/12/microsoft-flow-format-dates/

[Masor]

Yes it could be 🙂

But how can I change 'utcNow' to my dynamic inputfield in de Expression?

formatDateTime(utcNow(),'dd-MM-yyy')

formatDateTime(InputfieldForm(),'dd-MM-yyy')

[Pieter_Veenstra · Accepted solution]

HI @Masor,

In the expression editor you can move the curser to the spot where you want to add the dynamic content and then clikc onthe dynamic content tab and simply add it to your expression. 

[Dorul]

Hi @Masor

These 2 expressions might help you:

Convert UTC to eastern european standard time:

convertTimeZone(utcNow(),'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm')

or convert UTC to a response date from an approval:

convertTimeZone(body('Start_an_approval')?['responseDate'],'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm')

[Tom_Slosse]

Hey  @Masor

You could use convertTimeZone(Datumkeuze, 'Romance Standard Time',W.Europe Standard Time')

So the date and time are formatted in European standard.

Hope this helps 

Kind regards

Tom

[Masor]

When I use this expression:

convertTimeZone(utcNow(),'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm')

I get today's date in the corrrect format.

When I use this expression:

convertTimeZone(Datumkeuze(),'UTC','E. Europe Standard Time','dd/MM/yyyy HH:mm')

I get an error "incorrect expression"

What I want is the selected date in the Form and in the correct format.

My Formfield = Datumkeuze

[Tom_Slosse]

Hey @Masor

Your field Datumkeuze should be used like this convertTimeZone(DatumKeuze,...) not DatumKeuze().

It is not a function you call but the field so.

Kind regards

Tom

[Masor]

Now I've tryed:

convertTimeZone(Datumkeuze,'UTC','E. Europe Standard Time','dd/MM/yyyy')

But I get  'Errror in the expression'

[Masor]

Got it

convertTimeZone(body('Reactiedetails_ophalen')?['rcea83718ceb8419196ece9608750cb7a'],'UTC','E. Europe Standard Time','dd-MM-yyyy')

Italic: I selected there the dynamic field 'Datumkeuze'

Flow added then this text:  body('Reactiedetails_ophalen')?['rcea83718ceb8419196ece9608750cb7a']