Forum Discussion
How to move a Forms to OneDrive?
Caroline,
Did you ever get a satisfactory answer on how to move MS Forms to have the excel sheet responses show in onedrive? Other than rebuilding the form. It seems as such a easy thing but why the no-export or import not allowed?
Hi did anyone here succeeded in transfering Forms, that originally have been created in sharepoint Forms to Onedrive ?
O365 offers moving the form, but only to other shrepoint groups but not to onedrive.
I do not want to create all my forms again on onedrive just to be able to have all replies in one spreadsheet.
Thanks in advance
- Carlos HurtadoMar 05, 2021Copper ContributorI use Power Automate to move all results to an Excel file in OneDrive. It happens automatically after each response is received and in some cases additional things happen like send an email with results analysis or warn a student on specific areas for improvement. All automated.
Power Automate is a tool with superpowers. Once you learn the basics and start unleashing the powers you will realize you can't live without it. 🙂- DavidEMillingtonDec 13, 2022Copper ContributorWould you care to share how you do this with Power Automate?
- PQPQPQMar 05, 2021Copper Contributor
Carlos Hurtado Thank you very much for your input.
I have played around with power automate for approvals and mail notifications.
I might need some hints how to move new form entries into a certain excel. Is there any source you could advise to me or maybe some help that you can provide from your side? Any help appreciated :- )
Also I was wondering, if the results could be automatically put into a preformatted pdf and that is going to be send around, all automatically.
Cheers
- Carlos HurtadoMar 05, 2021Copper ContributorI'd say the best place to start is to use a very basic template that you can use in Power Automate that does exactly that: add every response to Excel. Do a search in PA with forma and excel keywords. Let me know if you don't find it to jump into the computer and do the search. In my cellphone it's harder to do so.
With respect to PDF, sure you can do that. There are actions to create PDF documents and share via email with subscribers. 100% automated.