How to Create a SharePoint Online Quiz with Instant Feedback Without Microsoft Forms
Question details
The user wants to build a quiz in SharePoint Online that calculates scores and provides immediate feedback upon submission, specifically without using Microsoft Forms.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Setting up an interactive quiz or assessment for team members directly within a SharePoint environment to track answers and immediately display results.
- Observed behavior
- The default SharePoint Online Survey app lacks the built-in conditional logic to validate correct answers, calculate a final score, and instantly display feedback after submission.
Ensure you have the necessary permissions to create custom lists on your SharePoint site, as well as an active Microsoft 365 license that grants you access to Power Apps for list customization.
Use a Custom SharePoint List Integrated with Power Apps
By creating a backend database with a SharePoint list and replacing the default form with a Power Apps interface, you can easily implement validation logic for instant grading and feedback.
This approach allows you to fully customize the quiz interface and write dynamic formulas to check the user's input against the correct answers stored in your list.
Navigate to your SharePoint site, click 'New', and select 'List'. Add necessary columns such as Question, Answer Choices (Choice column), Correct Answer, Score (Number column), and Feedback (Text column).
With your custom list open, click 'Integrate' on the top command bar, hover over 'Power Apps', and select 'Customize forms'. This will open the Power Apps Studio.
In Power Apps, replace the default data cards with interactive controls like Radio buttons or Dropdowns for the answer choices. Arrange labels clearly to present your questions.
Use Power Apps formulas on the 'OnSelect' property of your submit button. Write an 'If' statement to compare the user's selected value with the hidden 'Correct Answer' value to calculate points.
Create a new Success Screen in Power Apps. Configure it to appear immediately after form submission, displaying variables that hold the user's total score, correct answers, and customized feedback.
Try WPS Office for Your Document and Form Needs
If you are looking for a highly compatible and lightweight alternative to Microsoft Office, WPS Office offers comprehensive tools for documents, spreadsheets, and presentations with a familiar user interface.
- 1. Visit the WPS Website: Go to the official WPS Office website on your web browser.
- 2. Download the Software: Click the 'Free Download' button to get the lightweight installation package.
- 3. Install and Work: Run the installer and start enjoying a highly compatible office suite right away.
Frequently Asked Questions
Can I use Power Automate instead of Power Apps to grade the quiz?
Yes. You can use a standard SharePoint list and set up a Power Automate flow that triggers 'When an item is created'. The flow can calculate the score based on list data and send an email with the feedback, though this feedback won't appear instantly on the screen like it does with Power Apps.
Why doesn't the default SharePoint Survey app support this?
The classic SharePoint Survey app is designed strictly for data collection and polling. It lacks the built-in conditional logic and computational features required for dynamic grading and returning immediate feedback to the user.
Are there limitations to using a custom list for a quiz?
Managing a very large repository of questions or randomizing question banks can be complex in a standard SharePoint list. For highly advanced e-learning requirements, dedicated Learning Management Systems (LMS) or Dataverse-backed Power Apps are often a better fit.
Do users need a specific license to take a quiz built with Power Apps?
Yes, users taking the quiz must have an active Microsoft 365 license that includes Power Apps for Office 365. They also need proper 'Contribute' or 'Add Items' permissions to the underlying SharePoint list.
