Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

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

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

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

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?

 

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: using flow to extract forms response data to excel table stored on sharepoint

    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

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,017 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans