cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

MS Forms Flow Date Convert

Hi,

 

I have created a simple Flow (Form to email). I have a date question in the form but Flow converts the date incorrectly (YY/MM/DD). I need it to display DD/MM/YY. Can anyone advise how I can ensure Flow has the correct date format? So on the email the date field reads  DD/MM/YY?

 

Many thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Please use the function formatDateTime which can be used to return any specified format.

 

With reference to your requirement you can use:

formatDateTime(triggerBody()?['Date'],'dd/MM/yyyy')

 Let me know if this helps? 

View solution in original post

3 REPLIES 3
Super User III
Super User III

Please use the function formatDateTime which can be used to return any specified format.

 

With reference to your requirement you can use:

formatDateTime(triggerBody()?['Date'],'dd/MM/yyyy')

 Let me know if this helps? 

View solution in original post

Sorry for such a long delay in my response but I just want to say thank you, this worked!

 

Thanks again

Kieran

@KJC i am glad that your problem has been resolved..

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

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!

Users online (93,620)