Power Platform Community Forum Thread Details

I am looking to use a microsoft form to save peoples inputs in an excelfile(1). I am then looking to take the data from excelfile(1) and input it into a new excelfile(2) that is generated from an existing template excelfile(3) and saves it with in my sharepoint with a new id based on each new user input into the form. Any help would be appreciated as this is my first flow I'm creating!

Categories:

Using flows

Hi @TanJacketChem,

It would be better to use a template to add the records. I would like to suggest the following template:

1. Create from Template:

2. Select "Insert a row in an Excel spreadsheet when Microsoft Forms is submitted"

3. Select a place that you would like to add Excel location

4. I chose OneDrive for Business

5. Now, the important thing that you keep in mind is the Excel should be created with "Table" name that you will add the values in a row. Open your Excel application in local (Some excel online UI can't add table name) and create a table: