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.

(0) Share

Report

Posted on by TanJacketChem

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!

All responses (1)

Answers (0)

JisungHan on at

Like (0)

Report

Re: 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.

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:

6. In design tab, you can add a name without blank (ex: From_Forms) and save

7. Upload this file to OneDrive

8. Select MS form you created and add the Excel location as below:

9. You can remove the rest of Flow cards under the excel which is not necessary

Hope this helps. Thanks!

Regards,
Jisung Han
If this post helps, then please consider Accept it as the solution to help the other members find it more