cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Masor
Level: Powered On

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
Super User
Super User

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
Super User
Super User

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/

Masor
Level: Powered On

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

Super User
Super User

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

Dorul
Level 8

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!





Super User
Super User

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





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

Proud to be a Flownaut!





Masor
Level: Powered On

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

Super User
Super User

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





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

Proud to be a Flownaut!





Masor
Level: Powered On

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'

Masor
Level: Powered On

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 Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 70 members 3,507 guests
Please welcome our newest community members: