Answered

Converting date from MS Form (dd/MM/yyy) to SharePoint List?

(0) Share

Report

Posted on by PJ_Bowman98

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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
PJ_Bowman98 18 on at

Like (0)

Report
Copy link

Link copied!

Hi @MarconettiMarco
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.

formatDateTime(outputs('Get_response_details')?['body/r32f8311fe8c44656be4fd094ece24cf0'],'yyy/dd/MM')

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Ok, I see that’s not in String format.
So, please use this expression:
formatDateTime(string(<your_value>), ‘yyy/dd/MM’)

Was this reply helpful? Yes No
PJ_Bowman98 18 on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

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

Was this reply helpful? Yes No
PVaartstra 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No