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

Announcements

News and Announcements icon
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 Microsoft Employee

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
    Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard