I have a flow set up that takes the Audit results from a Microsoft Form I created and inputs it into a SQL table. The issue is it on only gives me the option to flow the questions but I want the start time (or complete either works) and the user to be included as well. These are columns on the excel file you can generate but don't come through as options in Flow.
even i am stuck , cannot find a solution so far .
I don't think this actually helps; wouldn't this just return the time the flow started, not the time the user began the MS forms survey?
I think what the above user—and what I'm looking for—is a way to return the times when the user first began viewing the form and when they clicked submit. This information can be seen on the Forms results page, and also can be exported to Excel (as start and completion times), but for some reason Flow only can grab the submission (or completion) time.
Thanks!
Hi @Anonymous,
If you want to get the Response time and responder, you should add the Get Response details after the trigger, for example:
If you want to get the Flow Start time, you could use the utcNow() function to get the Start time of the Flow, once the Flow perform, the utcNow() will return current time:
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.
Share
Report
All responses (
Answers (
25
