Unanswered

Flow Start (or complete) time and User from Forms to a SQL Table

(2) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building flows

All responses (6)

Answers (0)

Sort by

Gristy 2,429 on at

Like
a
(1)

Report
Copy link

Link copied!

Please provide more information perhaps some screenshots of your flow.
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
gbhcvt 8 on at

Like
a
(2)

Report
Copy link

Link copied!

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!
moustache 3 on at

Like
a
(0)

Report
Copy link

Link copied!

I have this exact issue. The start and completion times are being recorded into the results but are not being offered to map to SQL. Did you ever find a solution?
pchettri 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Even im stuck with the same "Start Time", any solution ?
arunramanathan 25 on at

Like
a
(0)

Report
Copy link

Link copied!

even i am stuck , cannot find a solution so far .