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 Excel file. Can you think of any option to do it?
- 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 UserRobElliott 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)
- @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
