How to establish automatic data transfer from MS Forms to Excel (Using Power Automate)

In this video, I will show you how you can create an automatic connection from Microsoft Forms to Microsoft Excel. This automatic connection will automatically transfer the data entered into the Form, to an Excel table, so that the Excel Table automatically updates when a new Form is submitted.

so before this video a Form and an Excel table have been prepared, so the focus of this video is to explain the connection between these, and to show how to build a Power Automate flow, that can handle the automatic data transfer. This will also provide insights into the very basics of the online version of Power Automate.

This video will answer the following questions:
- How to transfer data from MS Forms to Excel Automatically?
- How to create an automatic connection from MS Forms to Excel?
- How to build a simple Power Automate Cloud Flow?
- How to save time using Power Automate?
- How to create a link between MS Forms and Excel using Power Automate?

[MechanicalMadness]

Thankyou so much, this was exactly what i was looking for. I use this to add expenses to a spreadsheet to track my personal finance.

[juvyboiser]

Thank you so much! Your video helps me complete my project at work! 😊

[keerthanaselvaraj]

Thank you for this video. It helped me to finish my work quickly and it was easy to follow.

[loveduciel]

Great video, clear, easy to understand and not beating around the bush. Im a subscriber now

[cathytaylor]

Thank you so much- this was incredibly helpful, and saved me a lot of time and grief 🙂

[ElīnaFatejeva]

Hello! Thanks for the video - helped me a lot! :) I have a question - I saw that you submitted form on 11:01, however submission time on excel shows 10:01. Is it possible to fix submission time for one specific time zone?

[mabr]

Thanks awesome, what if the form have upload file get the link file and insert the column like other column?

[apple]

Wonderful! Thanks for the brilliant video, it was so helpful :)

[krisaumann]

Thanks a lot. Really helpful. Kind regards.

[YashJaiswal-bj]

Hi, I truly appreciate you fir making this video. I have a question though, when I am using the action "Get response details", I am only getting the "Response ID" in the dynamic content tab. I don't see the "List of response notification Response ID" option at all. If I use the "Response ID" option, I always get error. What should I do?

[sam-baa]

Hi thanks for making this video. Very helpful
Can you guide me further?
When creating step to add a row in excel “ in dynamic content” tab I am unable to see my responses from MS FORM.
How to fix this?

[CyndiLH]

If I have edited the spreadsheet that the form data goes to, is this a problem? e.g. it's not creating a new spreadsheet every time and it's only updating the new information and not syncing the old information (and deleting my edits)

[KS-qxwx]

Is there a way to automate the data in separate tabs within the same excel workbook? For instance, I have 200 employees who have to submit daily stats, instead of making each of them their one form is there a way to automate the submissions based on each employees name into their own tab?

[AleksandraOrysz]

Hi! Is there a possibility to create an automation for a surveys I am not an owner of, but I do have an access to edit it as it was shared with me? I can see the surveys in my account (Forms app/ Shared with me)), but I can not chose any of them in the Power automate app while creating a flow (New Flow/ Automated cloud flow/ When a new response is submitted/ Pick a form/ xxx). How should I approach this issue?
Thanks in advance and thanks for the video!

[cxr]

Is there a way to clone the workflow and all associated forms and excel files in case you wish to have different porjects?

[moisestatis]

I liked your video very much, thank you. Only one thing I do not complete to understand. Why do you make another file/table to link and make a flow to power automate? The Form already has an Excel file/table for storage data. When I open Excel file is updated with the forms information received. The only benefit that I see is cutomizing headers in new table (no need to use headers from Form). Thanks for claryfing my inquiry.

[Tom]

I've created a similar data base however I have a column in which the user has to enter the date that they have completed the said training which they are putting into the data base, however when its input into excel it also has a time alongside the date which has not been entered and i do not want there. how do i remove it?

[joneszzz]

Great vid. Thanks. I need help though. My scenario: I have numerous forms. I would like to collect all the data into one excel file...use different worksheets (tabs) at bottom for each form. How would I direct the data to go to different worksheets inside the same file? Help is appreciated :)

[brinda]

Hi i really like your video but I encountered an issue. When it came to the part about document library, you selected OneDrive, but I was not able to select it at all, I couldn’t connect to it even if I typed it out manually. I tried searching online for help, but they couldn’t really help me. Please help me 😢

[e.m.p.pathways]

Can I add additional columns that aren’t in the form and still have the excel sheet update?