
Announcements
When viewing response info in forms, I am able to view the time taken to complete the form and also (if it is a quiz) the overall score / number of points earned. For my purposes these are the only two variables of interest. However, when using flow to export response data to an excel table stored in sharepoint, these variables (which are clearly collected) are not available to add into my table with dynamic content. Viewing the "open in excel" option within forms -> responses directly, I need columns A (time started), B (Time ended) and E (total points). What am I doing wrong?
Hi @ eraiewski,
Could you please share a screenshots of your flow’s configuration?
Do you want to extract forms response data to excel table stored on sharepoint?
First of all, inserting row to excel table stored on sharepoint directly is not supported in Microsoft flow currently.
Second, Microsoft flow could support to get the Responders’ Email ,Submission time dynamic content and the questions value in action “Get response details” now, the dynamic content of columns such as “Time started”, “Time ended” and “total points” is not supported currently.
You could post your idea in the Flow Ideas forum, so it might be considered for future releases.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Regards,
Alice Zhang