cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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

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
Highlighted

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

HI @Masor,

 

Is this formatDateTime function what you are looking for?

 

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

Highlighted
Advocate III
Advocate III

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

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

Highlighted

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

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

Highlighted
Resolver III
Resolver III

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

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!





Highlighted
Memorable Member
Memorable Member

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

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.

Highlighted
Advocate III
Advocate III

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

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

Highlighted
Memorable Member
Memorable Member

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

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.

Highlighted
Advocate III
Advocate III

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

Now I've tryed:

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

 

But I get  'Errror in the expression'

Highlighted
Advocate III
Advocate III

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

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
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,690)