Aug 02 2022
11:30 AM
- last edited on
Aug 03 2023
05:18 PM
by
TechCommunityAP
Aug 02 2022
11:30 AM
- last edited on
Aug 03 2023
05:18 PM
by
TechCommunityAP
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/22 13:17:32) extracted doesn't seem to be excel compatible. What I mean is that I am unable to reformat it using the format cell functionality, or even transform it into a number, as you can with standard dates in excel.
I am just wondering if I am missing something here or whether I need to get the user to actually select the date of submission?
Aug 02 2022 12:02 PM