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

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,945)