Microsoft Forms Submission Time Issues

[ZachJayy]

This one is a relatively straightforward issue. I am using a Microsoft Form to collect data. My workflow gets those details and uses them to populate columns of a list. I'm pulling "Submission Time" from the form into a column in SharePoint formatted as a date column with "include time" checked. I have two issues:

1. No matter when the Form is submitted, the time is only coming across as 12:00am.

2. At noon, the date moves forward one day, so it seems that the Submission Time is out of phase by twelve hours?

[ZachJayy]

Update. I converted the submission time using the Convert Date/Time action and used that content for the column in a test run. It is now pulling through the correct date and a time field that isn't just "12:00am". So it wasn't retroactive, but seems to be working going forward. 

My issue now is this - 

I have one column that it a "Date and Time" column and a second column that is a "Single Line of Text" column.

I'm inputting the "Converted Date/Time" content into both of those columns as I test.

And it's giving different times. The same piece of data is registering differently in different columns.

I submitted a form at 7/2/2020 8:45pm.

The "Convert Date/Time" action is adjusting from UTC to UTC-6:00.

The "Date and Time" column in the list is displaying 7/2/2020 3:45pm.

The "Single Line of Text" column in the list is displaying 7/2/2020 8:45pm. (which is the correct timestamp)

Why is the same piece of data displaying differently in these two places? And how can I get it to register the correct date in my "Date and Time" column?

Thanks so much.

[v-litu-msft · Accepted solution]

Hi @ZachJayy,

I tested on my side that put the submission time into the SharePoint column, but not find the same issue that time always is 12:00.

Then the date shows in SharePoint is like as below:

Cause my input all 7/3/2020 8:33:17 AM, so if the column (SubmitTimeTxt) is Single text, it will display as normally;

If the column is a Date&Time column, it will automatically adjust to your local time zone, my timezone is utc-8, it will sub 8 hours, and cause daylight time will add 1 hour, so it will display 7/3/2020 1:33:17 AM finally.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.