Forum Discussion
Submission date and time for Forms extracted using power automate
I am using power automate to extract responses from a Form into excel. I had thought that I would be able to use the forms generated submission date/time for analysis. However, the format (7/27/...
I should add that I have tested the excel file that you download directly from Forms and that does maintain the integrity of the excel date format. So it appears to me that power automate is just taking the date/time format at 'face value' and ignoring and 'intelligence' within the value. Does that make sense?