Others

Can Microsoft Forms Remember Rankings Across Multiple Questions?

Aamir Naveed Akram Oct 1, 2026 868 views

Question details

The user wants to create a progressive ranking activity where participants narrow down choices (e.g., from 15 to 10 to 5) across multiple questions and receive a printable copy of their final selections.

Can Microsoft Forms Remember Rankings Across Multiple Questions?

Product: Microsoft Forms
Device & OS: not provided
Scenario: Designing a multi-stage assessment or survey requiring dynamic carry-over of selected and ranked items to subsequent questions.
Observed behavior: Microsoft Forms supports ranking items within a single question but lacks the built-in capability to automatically remember selections and pipe them into subsequent questions for progressive narrowing.

Before you start

Because Microsoft Forms does not natively support dynamic answer piping between questions, you will need to rely on clear manual instructions within the form or utilize advanced integration tools like Power Automate.

Solution 1Recommended

Use Manual Instructions for Successive Ranking Questions

Since automatic piping is unavailable, you can structure your form by explicitly asking participants to manually re-select or type their top choices in the following sections.

This method requires no advanced programming or external applications. While it relies on the participant to accurately remember and re-enter their previous top choices, it is the most straightforward workaround within the native Microsoft Forms interface.

Create the Initial Ranking Question

Open your Microsoft Form, click 'Add new', select 'Ranking', and input your full list of 15 personal values or choices.

Add a Follow-Up Instruction Question

Click 'Add new' and select 'Text' or a multiple-answer 'Choice' question. In the question title, explicitly ask the user: 'Based on your previous ranking, please select/type your top 10 choices from above.'

Repeat for Final Narrowing

Add a final question using the same method, asking participants to narrow their 10 choices down to their final top 5 selections.

Enable Form Receipts for Printing

Go to the form settings (three dots in the upper right), click 'Settings', and check 'Allow receipt of responses after submission' so participants can print or save a PDF copy of their final 5 choices.

Use Manual Instructions for Successive Ranking Questions

Form Design Tip: Use the 'Section' feature in Microsoft Forms to separate each narrowing stage onto its own page, making the progressive activity feel more structured for the participant.

Solution 2

Build a Custom Flow with Power Apps and Power Automate

For a fully automated and dynamic experience, bypass standard Microsoft Forms and create a custom application using Power Apps linked to Power Automate.

Free Microsoft Office alternative

Create Printable Forms and Templates with WPS Office

If Microsoft Forms' limitations are holding back your progressive ranking activities, you can design highly customizable, printable form templates and worksheets using WPS Office. It is a completely free, lightweight, and powerful alternative to Microsoft Office.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
2. Open WPS Writer: Launch WPS Writer to start a new document for your progressive ranking worksheet.
3. Design and Print: Use tables, checkboxes, and form controls to design your activity, then easily print or export it as a PDF.

Free and lightweight Office suite for everyday tasks.Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Easily design rich, interactive printable forms in WPS Writer.Familiar user interface makes transitioning effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Can I pipe answers from one question to another in Microsoft Forms?

No, Microsoft Forms does not currently support answer piping. You cannot dynamically take the choices a user made in Question 1 and automatically display them as options in Question 2.

How can participants get a printable copy of their Microsoft Forms responses?

You can allow this by going to your Form Settings and checking the box for 'Allow receipt of responses after submission'. After submitting, participants will see a button to print or save their responses as a PDF.

How do I request progressive ranking features from Microsoft?

You can request new features or vote on existing requests by visiting the Microsoft Forms Feedback Community portal at feedbackportal.microsoft.com.

Office Quick Solutions