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...
SergeiBaklan I already have an online form, and I can open the responses in Excel. But it just shows the responses up to that point. When new responses come in, the Excel spreadsheet does not automatically update. So I have to open multiple worksheets. Is there a way for me to connect an online Excel spreadsheet to the Form, so that it automatically updates? I would prefer not to create a new form.
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?
