cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dynamictiger
Helper I
Helper I

Ms Forms Fields and TimeDate Formatting

I have tried searching but perhaps am not seeing the obvious, apologies if this is the case.

 

I have built a leave form for our staff in MS Forms.  On this form is a field first day off work.  In the form when the user selects a date it shows with our appropriate local setting being dd/mm/yyyy.

 

However in Flows every time I add it, it shows as yyyy-mm-dd in the details email generated for approval, which is very confusing for the office staff who are processing the form.  

 

I thought this would be as simple as FormatDateTime(MS Form Field, 'dd/mm/yyyy') however this doesn't seem to work when I drag the form field into the expression:

 

 

formatDateTime(outputs('Get_response_details')?['body/r38416d29171b42229812393a7ffc6527'],'dd/mm/yyyy')


formatDateTime(outputs('Get_response_details')?['body/rd0e694ea7185464783419ad2f810b47d'],'dd/mm/yyyy')

 

 

Which is resulting in 16/00/2020 to 04/00/2020 for 16/04/2020 to 04/05/2020?

 

Bit frustrating...But clearly I am missing something?

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @dynamictiger 

 

Format should be dd/MM/yyyy. In your case you are using all small case letters.

 

Thanks

 



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

Hi @dynamictiger 

 

Format should be dd/MM/yyyy. In your case you are using all small case letters.

 

Thanks

 



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

I just realised by mucking about, but thanks for helping

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,661)