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?
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:
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).
Use a formatDateTime() expression for each of the three date columns:
formatDateTime([insert date from Dynamic properties],'yyyy-MM-dd')
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.