New features in Microsoft Forms - July 2017

Published Jul 26 2017 03:15 AM 24.6K Views

Forms for Excel

The Excel Survey feature is now powered by Microsoft Forms, and renamed “Forms for Excel”. This update allows Microsoft Excel users to easily create surveys and collect responses within their workbooks, and take advantage of most of the features available in Microsoft Forms. For more information, see this article: Microsoft Forms and Excel workbooks.

excel survey-1.png

New Question Type - Ranking

In response to one of our most popular customer requests, we will be introducing a new question type: ranking. Survey and quiz creators can now ask respondents to rank answer choices, and their responses will be aggregated and visualized for easy analysis. Ranking is a great way for survey creators to understand their respondents’ personal preferences. In the classroom, teachers can list several options within a quiz, and ask their students to rank them in the right sequence. This new question type will be available by August to all uses.


Auto-grading in Quizzes

Teachers can now show auto-grading in quizzes so they can give students immediate feedback on their answers. This feature is available for questions with text answers. Once they submit their answers, students can see how many points they received and what the correct answers are for each question.

 auto grading.png

Microsoft Forms and Microsoft Flow integration

Users can now define connectors for Microsoft Forms via Microsoft Flow. A great use case for this is setting up a connector to receive the email notifications whenever a new response is submitted for a survey or quiz. Use Microsoft Forms connector templates or create your own at


Accessibility Improvements
We’re dedicated to delivering great product experiences for ALL users, and are happy to improve on several features for people with vision, mobility and cognitive difficulties.
Occasional Contributor

Yes, yes, yes...... Way to go Forms Team! All great new additions!!!!! Excited to try them all out and share at training in a couple weeks. 

Occasional Visitor

Not sure if this is the right place for such a comment but I'd like to suggest the ability for the form submitter to be able to add an image. I.e. complete form and add a web cam self image?

Not applicable

Just created a Form, connected it to Flow, and set it up to send both myself and the individual submitting a form a response email! You all have done a great job on this! Love the Flow feature, conditionals, add-ins, and dynamic content. 


Nicely done! 

Frequent Contributor

Will a SharePoint library also be upgraded with Microsoft Forms in stead of excel survey?

At this moment I have Forms in my OneDrive but in a SharePoint library I still have the Excel option.

@Kathy Liu We found that if a user is not licensed for forms that this link is still available. When clicking the link, it creates an empty excel file and throws the error that your account is not enabled for forms.


Is it possible to hide the "Forms for Excel" link when Forms is not licensed? 

New Contributor

Is there a way to include the form responses within the notification?

Occasional Contributor

Yes that is all available as options when you set up the flow.  There are drop down boxes that let you add content fields to the notification email from the flow generator.

New Contributor

Thanks @John Bimmerle!
Currently the flow takes an hour for me to receive the test e-mail. Is there any way to speed the proccess up?

When creating ordered lists (Rank the following options...) How can one remove the correct/incorrect options summary that appears when submitting responses?  The idea is just to get feedback so there is no right or wrong answer.

Occasional Contributor

@Naftoli Jacobs I see delayed information too.  I am not aware of a way to resolve that, but at least we can now get some sort of alert, it beats no info.  Hopefully over time it will continue to get better.



Occasional Visitor

I would love a filter on answers. E.g. only integers accepted, only "," as decimal marker etc.

Version history
Last update:
‎Jul 26 2017 10:12 PM
Updated by: