Forum Discussion
Copy form questions into another form?
veroa my recommendation is to always start from Forms. Did you see that when you are designing the form and testing it, if you go to the Responses tab the form is saved as a spreadsheet anyway? If you then need to put the responses into a different spreadsheet you'd need to do that with a flow in Power Automate or a copy-and-paste. But the spreadsheet of responses is there for you already.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott surely you should never start with the Form as the spreadsheet is then saved locally when downloaded. which makes it impossible to do any collaborative work. On the other hand by simply creating the spreadsheet in Office 365, and clicking Insert Form etc. the spreadsheet is then saved in Sharepoint which facilitates collaboration, and you can see the form entries updating in real time.
MS Forms is very basic and clunky to use and is years behind Google Forms in terms of ease of use.
