Forum Discussion
How to automatically download the Excel file corresponding to a Forms form?
I need to regularly download the Excel files of several forms, and I would like to do it directly from Power Query (Import from Web option), without the need to go into each form and download the Exc...
- Really thank you so much RobElliott!!!! Finally, I've figured out how to do it! If you create the form directly from Excel, all the answers are collected in that Excel file.
Nacho_P you won't be able to do that directly I think. What I do is that when a response is submitted I use a flow in Power Automate to get the details and add it to either a SharePoint list or to a row in a different spreadsheet in One Drive.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott thank you very much for your answer. I tried it, but there are 2 fields that I can't get, but they do appear in the excel that you can download directly from the Forms website and that I am interested in: On the one hand the date/time of the beginning of filling in the form, and on the other hand the name of the person (I know that I have the email as an option)
