Forum Discussion
How to move a Forms to OneDrive?
Hello, An user has created a Forms directly with the app Forms, so now when she wants to open answers in Excel, she has to download a file and there's no excel file in OneDrive. Is it possible to "...
I 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. 🙂
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. 🙂
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
- I'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.