Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Save MS Forms responses to multiple Excel sheet

Like (0) ShareShare
ReportReport
Posted on 19 Nov 2021 09:20:47 by 10

Hi, 

I want to build a flow that stores the results of the forms in separate Excel sheets and create a 'master' sheet where you link from each of the separate ones.

employee13_1-1637313581062.png

 

 

  • edwarde Profile Picture
    2 on 07 Dec 2023 at 10:12:48
    Re: Save MS Forms responses to multiple Excel sheet

    I have form that has one of the questions "week beginning". I want the the excel to push every response that has same date to a new sheet in the same workbook. 

     

    For example, if two responders select WB 27/11/23, then the results should go to a new sheet. if another 3 responders selects WB 04/12/23 then  all their responses should go to a new sheet.

     

    I hope this is a clearer explanation.

     

    How can i do this? is there a video tutorial to help.

  • Verified answer
    v-jefferni Profile Picture
    on 26 Nov 2021 at 09:28:44
    Re: Save MS Forms responses to multiple Excel sheet

    Hi @employee13 ,

     

    Based on your description, I would recommend you to store a template excel in SharePoint library or OneDrive, copy the file, rename it with the response content, and add the response into this copy.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • employee13 Profile Picture
    10 on 23 Nov 2021 at 11:34:45
    Re: Save MS Forms responses to multiple Excel sheet

    Hi @v-jefferni 

     

    Thank you for getting back!

     

    I want to be able to have a whole new separate excel file every time a response is submitted. So I have managed to get that working but the problem I am having is, the new excel sheet must have the same table of responses that is in the master copy. So every time a response is submitted, it creates a new excel sheet (where it has copied the table of responses from the master excel) and then it is adding the submitted responses for that user into the new separate excel file it has created. 

  • v-jefferni Profile Picture
    on 23 Nov 2021 at 07:26:56
    Re: Save MS Forms responses to multiple Excel sheet

    Hi @employee13 ,

     

    Could you please share more details about your scenario? I still could not get the point, assuming there will be 100 users to fill a form then they will submit to 100 excel sheets?

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • employee13 Profile Picture
    10 on 19 Nov 2021 at 09:26:51
    Re: Save MS Forms responses to multiple Excel sheet

    Just to add to the previous question, what I mean by storing multiple responses is every time a user fills out a form I want to save the responses in separate excel sheets for each response.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 208 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 202 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 177

Overall leaderboard
Loading started