How to Allow Multiple Submissions and Send Feedback in Microsoft Forms
Question details
The user wants to configure a Microsoft Forms quiz to track recurring pupil well-being concerns, allowing users to submit the form multiple times and automatically receive feedback.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Using a quiz format to periodically assess and track well-being, requiring multiple entries over time without overwriting previous data.
- Observed behavior
- The form locks after a user submits one response, preventing them from taking the quiz again unless their previous response is manually deleted by the administrator.
Ensure you have access to a Microsoft 365 Business or Education account with active licenses for SharePoint Online, Power Apps, and Power Automate, as this advanced workaround requires utilizing these integrated tools.
Create a Custom Workflow Using SharePoint Lists and Power Automate
Since Microsoft Forms lacks the advanced permissions required to repeatedly submit a locked quiz and send automated feedback, building a custom workflow is the best workaround.
Microsoft Forms is excellent for simple data collection but falls short for recurring interactive quizzes that require automated responses and reset capabilities without deleting prior data.
By utilizing SharePoint Lists alongside Power Apps and Power Automate, you can build a robust system that tracks well-being concerns while retaining user-specific submission capabilities and privacy.
Navigate to SharePoint Online and create a new SharePoint List to act as your database. Add columns corresponding to the questions you want to ask your participants.
From your SharePoint List, select 'Integrate' > 'Power Apps' > 'Customize forms' to create a user-friendly interface that natively allows for multiple entries without locking the user out.
Go to your SharePoint List settings and adjust the advanced permissions so users have the ability to add new items but can only view their own submissions, keeping data private and secure.
Open Power Automate and create an automated cloud flow triggered by 'When an item is created' in your SharePoint List. Add an action to 'Send an email (V2)' to automatically send customized feedback to the submitter's email address.
Enhance Your Productivity with WPS Office
While advanced data automation might require specific Microsoft ecosystem tools, WPS Office is an excellent, free alternative for your daily document creation, spreadsheet management, and presentation needs. It offers a lightweight experience with complete format compatibility and a highly intuitive interface.
Frequently Asked Questions
Can I turn off 'One response per person' in a Microsoft Forms Quiz?
Yes, if you open your form settings, you can uncheck the 'One response per person' option. However, depending on how your quiz is structured and shared, you might lose the ability to automatically track specific user identities or provide personalized automated feedback without relying on external tools.
How can I send customized email feedback after a Microsoft Form submission?
While Microsoft Forms has a basic 'Send email receipt to respondents' option in its settings, sending highly customized feedback based on quiz scores or specific answers requires setting up a Power Automate flow using the 'When a new response is submitted' trigger.
Can respondents edit their Microsoft Forms submissions instead of creating new ones?
Yes, if the form owner enables the 'Allow respondents to edit their responses' option in the form settings. However, this overrides the original submission data rather than creating a new distinct entry, which makes it unsuitable for tracking ongoing concerns over time.
