Forum Discussion
Solved
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
@RobElliot, I think it would be a good option to be implemented by Microsoft to keep always the same Link to download the Excel for each form, could you tell me how I can suggest this improvement/option to Microsoft?
Nacho_P the feedback portal is at https://feedbackportal.microsoft.com/feedback/forum/0ab9de26-ff1b-ec11-b6e7-0022481f8472
- 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.