web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / using flow to extract ...
Power Automate
Unanswered

using flow to extract forms response data to excel table stored on sharepoint

(0) ShareShare
ReportReport
Posted on by

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?

 

Categories:
I have the same question (0)
  • v-yuazh-msft Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard