You’re offline. This is a read only version of the page.
Hi,
I'm using a the 'Send form responses for approval' flow template which eventually sends Form data into a SharePoint List once approved.
I keep getting errors on how the date is formatted, instructing me that it must be in ISO 8601 format (yyy/dd/mm)
Can anyone advise how I can get around this or convert the format?
Many thanks
There should be no need for a Power Automated expression. Date fields should always store their data in an unambiguous structure. And any interface exposed between systems should provide the data in ISO-8601 compliant format. IMHO, storing the date format in the end-user's local format and exposing that same value in an interface is inexcusable. MS Forms' Date Field is broken.
Hi @PJ_Bowman98 ,
Do you want to save the timestamp in yyyy-dd-MM format submitted by the MS Form to the 'Date and time' column in the SharePoint List?
Maybe you could try the following expressions:
Share
Report
All responses (
Answers (formatDateTime(concat(split(Dynamic Content,'/')[0],'/',split(Dynamic Content,'/')[2],'/',split(Dynamic Content,'/')[1]),'yyyy/MM/dd')
formatDateTime(concat(split(outputs('Get_response_details')?['body/r32f8311fe8c44656be4fd094ece24cf0'],'/')[0],'/',split(outputs('Get_response_details')?['body/r32f8311fe8c44656be4fd094ece24cf0'],'/')[2],'/',split(outputs('Get_response_details')?['body/r32f8311fe8c44656be4fd094ece24cf0'],'/')[1]),'yyyy/MM/dd')
Best Regards,
Charlie Choi
@MarconettiMarco thanks so much - I tried the above for one of my date fields and it worked. But, I'm now getting this error! Any ideas?
Again thank you - I appreciate it as I'm new to all of this!
Ok, I see that’s not in String format.
So, please use this expression:
formatDateTime(string(<your_value>), ‘yyy/dd/MM’)
Thank you for responding!
I've used 'dynamic content' to add the MS Form Field in the <your_value> clause, (which turns into the below expression). I'm getting the error below. Perhaps my syntax is incorrect?
Thanks again.
Hello @PJ_Bowman98 ,
please use the following expression:
formatDateTime(<your_value>,'yyy/dd/MM')
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
