Forum Discussion
Real time Microsoft Forms results in Excel Worksheet
Hi, I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has...
To my knowledge that doesn't work.
If you create Form from the file saved on SharePoint/OneDrive all responses are collected in this file.
If create new Form without Excel, all responses are collected somewhere on Microsoft servers. With Open in Excel you download them from the server, but there is no connector to automatically pickup data from the server.
LaraTellis Alternatively you can use Power Automate and create a Flow that will automatically take data from the Form and add it to an online Spreadsheet you choose. Here is the basic structure I used
Obviously you will have to select your form and then when you click Add a row into a table you will fill that section out to which spreadsheet and which form input you want to go in which column.
Hope that helps
mtarler Would that power automate solution add the form's previous responses? Or just new ones?
Just new ones. But you may download Excel file from Forms and add old responses to the table with which Power Automate works.
- LaraTellis, as Sergei mentioned it will only add the new form entries so create the spreadsheet, add all the existing entries and then Power Automate flow will add new ones as they come in. As for how to get to it, when you are in any MS web app (Word, Excel, etc...) you should see a 9 dot grid in the upper left corner. Click that grid to find links to the rest of MS online Apps including Power Automate
- mtarler I am also not sure how you get to power automate. Is it a separate app?
