Create a Excel Spreadsheet from a response in a form

[calebtho]

I would like to create an excel spreadsheet from a response in a form - the new spreadsheet is to be based on a template i have set up

[#2]

 This can be achieved through the use of Power Automate. Try the steps on below and let me know if this helps for you.

1. Trigger: When a new response is submitted
   • Use the "When a new response is submitted" trigger to start the workflow when a form response is received.
   • Action: Get response details
     • Add the "Get response details" action to retrieve the details of the form submission. Make sure to specify the form and use the response ID from the trigger to get the specific submission details.
     • Action: Insert a row into a table
       • Use the "Insert a row into a table" action to add the form submission details into a specified table.
       • Choose the location or environment where you have the template.
       • Map the form submission values to the corresponding fields in the table.

         

@calebtho