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

MS Flow Date Format

I have a MS Form where I created 3 date fields.  I created a MS Flow to send the form response to a SharePoint list the date fomatting in the SharePoint list as yyyy-mm-dd I want to format all 3 date fields in the SharePoint list as mm/dd/yyyy.  I was able to format the 1st date field in MS Flow but when I went to format the 2nd date field in MS flow the Flow failed. Is there a way I can re-formate all 3 of my MS form date fields in the FLOW so they show in my SharePoint list as mm/dd/yyyy?

4 REPLIES 4
jennratten
Advocate I
Advocate I

Hello - can you please post some screenshots of your flow steps?

ScottShearer
Super User
Super User

@mgleason 

SharePoint stores all dates in the following format regardless of your locale or time zone: yyyy-MM-dd

You can format using the formatDateTime() expression.  For example:

formatDateTime(utcNow(),'yyyy-MM-dd') 

The date format displayed on your SharePoint site is controlled by the sites regional settings - go to site settings and then regional settings (under site administration).

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Date_Flow_LI.jpg

@mgleason 

Use a formatDateTime() expression for each of the three date columns:

formatDateTime([insert date from Dynamic properties],'yyyy-MM-dd')

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (1,471)