Using forms to populate an existing Excel file

Laurens2207 

In teams:

1. I would personal create a teams channel for yourself called Forms data or something like this, you can add people to this as admin if there is someone else assisting with the data ...

2. in that channel add a tab for forms

3. this gives you option to add an existing form ( I would create from scratch tbh thinking of all the stuff you may require on the form) (do not be afraid of testing the forms branching options as this can be really useful tool)

4. this then stores the forms excel in your teams channel files tab.

5. this excel you can edit loads on that will not show on the form, even make dashboards etc. 

6. this enables the form to be edited in that teams channel if you require it too... each edit will add an extra column on excel to end but you can drag the excel columns around without affecting your form

You can add the data from your other workbook to this workbook, as a one off then it will be there but not show on form  

if you was to ever leave business with it been in a teams channel if it had a 2nd and 3rd admin they would still be able to keep this form current in the company.

Laurens2207 

I was looking into this same issue and found an alternative solution. Forms for Excel.

In the appropriate Sharepoint (or OneDrive) folder online create a new file called Forms for Excel (using the New button). It will be tied to the created Form and live updated based on the form submissions. Unfortunately, I believe Forms for Excel can only be added to a new Excel file but you can copy over any old info from your current Excel file.

More info about creating Forms for Excel on this video. They talk about Microsoft Forms vs Forms for Excel. The Forms for Excel part starts at 3:00 if you want to skip ahead. This is not my video, just the simplest most to the point one I could find quickly.

https://www.youtube.com/watch?v=qbvjYjZyQBY

Laurens2207 the form can't populate File A directly but you can grab each form response with a flow in Power Automate and add the answers to each question to the appropriate column in a table in File A on OneDrive.

Rob
Los Gallardos
Microsoft Power Automate Community Super User