Unanswered

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

(2) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (6)

Answers (0)

Gristy 2,429 on at

Like (1)

Report

Please provide more information perhaps some screenshots of your flow.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
gbhcvt 8 on at

Like (2)

Report

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!

Was this reply helpful? Yes No
moustache 3 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
pchettri 39 on at

Like (0)

Report

Even im stuck with the same "Start Time", any solution ?

Was this reply helpful? Yes No
arunramanathan 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No