With Microsoft Forms you can create a form, such as a survey or quiz, invite others to respond to it using almost any web browser or mobile device, see real-time results as they’re submitted, use built-in analytics to evaluate responses, and export results to Excel for additional analysis or grading.

Microsoft SharePoint is a knowledge-based system. It is primarily used for documents but it also has the ability to use for list register.

Microsoft Form captures data and then populates the information collected into a SharePoint List. Every single response that is uploaded in Microsoft form is copied over the SharePoint list. We can use workflow to get each response to record as a row in the SharePoint list. One of the benefits of using Microsoft Forms is that there is no risk of losing data.

If you’re moving from Google forms into Microsoft, you have a few options, in the below table and video Kim explains and summarises the pros and cons of using Microsoft Forms or SharePoint or both as an alternative.

 Option 1Option 2Option 3
TechnologyJust MS FormsJust SP ListForms front end,SP back end
Pros
  • Prettier
  • Most similar to Google Forms
  • Easier to add questions yourself
  • Automatic results ‘summary
  • Multiple ‘file upload’
  • Sections
  • Data longevity
  • Can ‘edit’ single response
  • Version history
  • More data/table register solution, that happens to have a form to complete it.
  • Easy table view of responses to filter, group and summarise like Excel/Sheets
  • Totals/average ability in view
  • Best of both world
Cons
  • Risk of data integrity if a question is delete, past results for that question are lost
  • Cant see live table of results, only individual results or export in Excel
  • Cannot edit previous submission
  • If you want the ‘summary’ it’s individually auto created, or setup and published once buy you need Power BI ‘pro’ license
  • The styling isn’t as advanced
  • Adding new questions isn’t as easy
  • Branching logic and hidden fields is possible but not user-skill-level
  • More effort to build