Issue with date field on forms

%3CLINGO-SUB%20id%3D%22lingo-sub-572396%22%20slang%3D%22en-US%22%3EIssue%20with%20date%20field%20on%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-572396%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3Enew%20to%20creating%20and%20managing%20forms%20so%20please%20excuse%20any%20stupid%20questions.%3C%2FP%3E%3CP%3EI%20have%20setup%20a%20simple%20form%20for%20our%20warehouse%20person%20to%20input%20shipping%20information%20and%20one%20of%20the%20fields%20is%20to%20select%20the%20date%20the%20item%20is%20sent%20or%20received.%3C%2FP%3E%3CP%3EThe%20issue%20i%20am%20having%20is%20no%20matter%20what%20date%20is%20filed%20in%20when%20it%20comes%20through%20into%20the%20excel%20workbook%20it%20only%20shows%20as%20the%20current%20date%20and%20not%20the%20date%20selected.%3C%2FP%3E%3CP%3Eas%20shown%20on%20the%20JPG%2C%20i've%20created%20a%20new%20question%20and%20tested%20this.%20the%20responses%20on%20the%20right%20does%20not%20match%20the%20details%20on%20the%20left...%3C%2FP%3E%3CP%3EPlease%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-572396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-613848%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20date%20field%20on%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-613848%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342904%22%20target%3D%22_blank%22%3E%40LoganJames%3C%2FA%3E%26nbsp%3B%20how%20are%20you%20getting%20your%20forms%20response%20into%20the%20spreadsheet%3F%20Don't%20forget%20that%20Forms%20saves%20the%20responses%20to%20a%20spreadsheet%20anyway%20so%20you%20can%20always%20use%20that.%20But%20I've%20just%20done%20a%20quick%20example%20saving%20the%20Forms%20response%20to%20a%20a%20Excel%20for%20Business%20spreadsheet%20using%20Flow%20and%20it%20saved%20the%20date%20absolutely%20fine.%20The%20Form%2C%20Flow%20and%20Spreadsheets%20images%20are%20shown%20below%20and%20I%20selected%20the%201st%20May%202019%20as%20the%20date%20for%20the%20date%20field.%20It%20was%20converted%20to%20UK%20format%20with%20no%20problem%20by%20Flow%20and%20appeared%20correctly%20in%20the%20spreadsheet.%20So%20if%20you%20can%20let%20us%20know%20if%20you%20are%20doing%20anything%20differently%20then%20we%20might%20be%20able%20to%20get%20to%20the%20cause%20of%20the%20problem.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20813px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114295i006E24C652F92D86%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Form.png%22%20title%3D%22Form.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20Form%20fields%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20716px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114296iE060815BF2436671%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Flow.png%22%20title%3D%22Flow.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20Flow%20steps%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114297iF3E34B2D5A9B8591%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Spreadsheet.png%22%20title%3D%22Spreadsheet.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20spreadsheet%20result%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614075%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20date%20field%20on%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3EI'm%20not%20sure%20on%20how%20it%20all%20works%20in%20the%20backend%2C%20but%20i%20created%20the%20form%20and%20then%20just%20used%20the%20created%20spreadsheet%20to%20access%20the%20data.%20when%20i%20look%20under%20the%20flow%20pages%20i%20can't%20see%20any%20connections%20of%20information%20about%20the%20connection%20between%20my%20form%20and%20the%20spreadsheet.%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20create%20a%20connection%20between%20the%20form%20and%20the%20excel%20spreadsheet%20after%20the%20fact%2C%20or%20do%20i%20need%20to%20recreate%20the%20whole%20setup%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ELogan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557085%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20date%20field%20on%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20similar%20issue%20but%20mine%20is%20with%20a%20MS%20Forms%20--%26gt%3B%20MS%20Planner%20Task.%26nbsp%3B%20If%20I%20enter%208%2F7%2F2020%20as%20the%20date%20on%20the%20Form%2C%20Power%20Automate%20passes%20it%20to%20Planner%20as%208%2F6%2F2020.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20your%20convert%20time%20zone%20step%20but%20now%20I'm%20getting%20an%20error%3A%26nbsp%3B%26nbsp%3BThe%20request%20is%20invalid%3A%3CBR%20%2F%3ECannot%20convert%20the%20literal%20'2020-08-06T20%3A00%3A00'%20to%20the%20expected%20type%20'Edm.DateTimeOffset'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20is%20appreciated.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

new to creating and managing forms so please excuse any stupid questions.

I have setup a simple form for our warehouse person to input shipping information and one of the fields is to select the date the item is sent or received.

The issue i am having is no matter what date is filed in when it comes through into the excel workbook it only shows as the current date and not the date selected.

as shown on the JPG, i've created a new question and tested this. the responses on the right does not match the details on the left...

Please help

3 Replies

Hi @LoganJames  how are you getting your forms response into the spreadsheet? Don't forget that Forms saves the responses to a spreadsheet anyway so you can always use that. But I've just done a quick example saving the Forms response to a a Excel for Business spreadsheet using Flow and it saved the date absolutely fine. The Form, Flow and Spreadsheets images are shown below and I selected the 1st May 2019 as the date for the date field. It was converted to UK dd/MM/yyyy format with no problem by Flow and appeared correctly in the spreadsheet. So if you can let us know if you are doing anything differently then we might be able to get to the cause of the problem.

Rob
Los GallardosThe Form fieldsThe Form fieldsThe Flow stepsThe Flow stepsThe spreadsheet resultThe spreadsheet result

@Rob Elliott 

Thanks for your reply.

I'm not sure on how it all works in the backend, but i created the form and then just used the created spreadsheet to access the data. when i look under the flow pages i can't see any connections of information about the connection between my form and the spreadsheet.

is it possible to create a connection between the form and the excel spreadsheet after the fact, or do i need to recreate the whole setup?

 

Regards

Logan

@Rob Elliott 

I am having a similar issue but mine is with a MS Forms --> MS Planner Task.  If I enter 8/7/2020 as the date on the Form, Power Automate passes it to Planner as 8/6/2020.  

 

I tried your convert time zone step but now I'm getting an error:  The request is invalid:
Cannot convert the literal '2020-08-06T20:00:00' to the expected type 'Edm.DateTimeOffset'.

 

Any assistance is appreciated.  

 

Thanks!