Converting Dates from MS Forms into ISO 8601 Format for use in SharePoint datetime field

%3CLINGO-SUB%20id%3D%22lingo-sub-2361400%22%20slang%3D%22en-US%22%3EConverting%20Dates%20from%20MS%20Forms%20into%20ISO%208601%20Format%20for%20use%20in%20SharePoint%20datetime%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2361400%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20you're%20all%20keeping%20safe.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20a%20problem%20that%20I%20hope%20the%20community%20can%20help%20me%20with.%26nbsp%3B%20I'm%20designing%20a%20Forms%20to%20SharePoint%20workflow%20via%20Power%20Automate%20and%20some%20date%20fields%20are%20giving%20me%20some%20issues.%26nbsp%3B%20%26nbsp%3BI've%20got%20several%20date%20pickers%20in%20my%20forms%20that%20return%20data%2C%20which%20I%20then%20try%20to%20add%20to%20a%20SharePoint%20list.%26nbsp%3B%20The%20SharePoint%20List%20field%20is%20a%20date%20time%20configured%20to%20date%20only%20in%20the%20UTC%20format.%26nbsp%3B%20Sadly%20this%20doesn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20get%20around%20this%20via%20the%20Convert%20Date%20Time%20function%2C%20but%20this%20also%20fails%2C%20informing%20me%20that%20I'm%20not%20using%20the%20correct%20format%20of%20ISO8061%20for%20the%20Date.%26nbsp%3B%20This%20is%20where%20I'm%20a%20little%20confused.%26nbsp%3B%20I%20understand%20this%20date%20format%20to%20be%20YYYY-MM-DD%2C%20which%20is%20the%20exact%20format%20that%20Forms%20has%20captured%20its%20dates%20in.%26nbsp%3B%20I'll%20post%20a%20few%20screenshots%20below%20but%20any%20help%20in%20sorting%20this%20out%20would%20be%20very%20much%20appreciated.%26nbsp%3B%20I'm%20aware%20the%20response%20is%20in%20manipulating%20the%20Forms%20output%20but%20I'm%20not%20sure%20on%20how%20to%20proceed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3CBR%20%2F%3ESteve%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Convert%20Time%20zone%20configuration.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281087i96BAF6959F2361BA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Convert%20Time%20zone%20configuration.PNG%22%20alt%3D%22This%20is%20how%20I've%20configured%20my%20ConvertTimeZone%20action%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20how%20I've%20configured%20my%20ConvertTimeZone%20action%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Date_Field%20in%20Forms.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281088iBFB7F99748848DB3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Date_Field%20in%20Forms.PNG%22%20alt%3D%22This%20is%20the%20returned%20date%20format%20from%20Forms%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20the%20returned%20date%20format%20from%20Forms%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Workflow%20Error.PNG%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281089i683FCC7AC3285066%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Workflow%20Error.PNG%22%20alt%3D%22This%20is%20the%20error%20that%20the%20ConvertTimeZome%20returns%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20the%20error%20that%20the%20ConvertTimeZome%20returns%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2361400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365110%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Dates%20from%20MS%20Forms%20into%20ISO%208601%20Format%20for%20use%20in%20SharePoint%20datetime%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365110%22%20slang%3D%22en-US%22%3EThe%20case%20for%20date%20formats%20needs%20to%20be%20exact%3A%20yyyy-MM-dd%20is%20the%20correct%20format%20with%20only%20the%20MM%20in%20uppercase.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365606%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Dates%20from%20MS%20Forms%20into%20ISO%208601%20Format%20for%20use%20in%20SharePoint%20datetime%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365606%22%20slang%3D%22en-US%22%3EAny%20suggestions%20on%20how%20I'd%20achieve%20that%20format%3F%3C%2FLINGO-BODY%3E
Frequent Contributor

Hi all,

 

Hope that you're all keeping safe. 

 

I'm having a problem that I hope the community can help me with.  I'm designing a Forms to SharePoint workflow via Power Automate and some date fields are giving me some issues.   I've got several date pickers in my forms that return data, which I then try to add to a SharePoint list.  The SharePoint List field is a date time configured to date only in the UTC format.  Sadly this doesn't work.

 

I've tried to get around this via the Convert Date Time function, but this also fails, informing me that I'm not using the correct format of ISO8061 for the Date.  This is where I'm a little confused.  I understand this date format to be YYYY-MM-DD, which is the exact format that Forms has captured its dates in.  I'll post a few screenshots below but any help in sorting this out would be very much appreciated.  I'm aware the response is in manipulating the Forms output but I'm not sure on how to proceed.

 

Thanks
Steve

 

This is how I've configured my ConvertTimeZone actionThis is how I've configured my ConvertTimeZone actionThis is the returned date format from FormsThis is the returned date format from FormsThis is the error that the ConvertTimeZome returnsThis is the error that the ConvertTimeZome returns

2 Replies
The case for date formats needs to be exact: yyyy-MM-dd is the correct format with only the MM in uppercase.
Any suggestions on how I'd achieve that format?