cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate III
Advocate III

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

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"

1 ACCEPTED SOLUTION

Accepted Solutions

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. 

View solution in original post

9 REPLIES 9

HI @Masor,

 

Is this formatDateTime function what you are looking for?

 

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

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')

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. 

View solution in original post

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')

 

Capture.JPG

 

 

 

 

 

 

 

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')

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Memorable Member
Memorable Member

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



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

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

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



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Now I've tryed:

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

 

But I get  'Errror in the expression'

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']

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (9,426)