Others

How to Automatically Create a Microsoft Form from Another Submission

Maira Mehtab Sep 27, 2026 870 views

Question details

The user wants to automatically generate and prepopulate a second Microsoft Form based on the data submitted in a primary Microsoft Form.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating sequential forms where a secondary form inherits and prepopulates data directly from a primary form's submission.
Observed behavior: Microsoft Forms does not have a native feature to automatically create and prepopulate a new form from another submission without using third-party automation.

Before you start

Ensure you have access to Microsoft Power Automate and the necessary permissions to create automation flows within your Microsoft 365 workspace.

Solution 1Recommended

Use Power Automate to Coordinate Form Submissions

Since Microsoft Forms lacks a native linking feature, you must use Power Automate to capture submission data and pass it dynamically to subsequent forms.

Power Automate allows you to capture the submitted values from your first form and trigger actions such as sending emails with dynamic links to a second form, completely prepopulated with URL parameters.

Create an Automated Cloud Flow

Log into Microsoft Power Automate, click on 'Create' in the left menu, and select 'Automated cloud flow'.

Set the Trigger

Search for and select the trigger 'When a new response is submitted' for Microsoft Forms, then select your primary form from the dropdown menu.

Get Response Details

Add a new step, search for the 'Get response details' action, and link it to the Form ID and Response ID from your initial trigger.

Construct the Prepopulated Link

Generate a URL for your second form and append custom parameters that match the dynamic content extracted from the first form.

Send the Secondary Form

Add an action such as 'Send an email (V2)' to automatically email the generated link to the respondent or your internal team to complete the workflow.

Advanced Requirements: For highly complex automation, you may need to build a custom Power Platform solution. Reach out to the Microsoft Power Platform Community for advanced implementation guidance.

Free Microsoft Office alternative

Try WPS Office for Your Daily Productivity Needs

While complex sequential form automation requires Microsoft Power Automate, you can handle most daily documentation, data collection, and spreadsheet analysis effortlessly with WPS Office. It provides a lightweight, highly compatible alternative to the Microsoft Office suite.

1. Download and Install: Visit the official WPS website to download the free Office suite for your preferred operating system.
2. Open Existing Documents: Launch WPS Office and directly open your existing Microsoft Word, Excel, or PowerPoint files without losing any formatting.
3. Explore WPS Forms: Use the built-in WPS Form feature to quickly create surveys, collect responses, and automatically aggregate the data into a WPS Spreadsheet.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats.Includes built-in WPS Form tools for easy surveys and data collection.Lightweight software that runs smoothly on Windows, Mac, and Linux.Free to use with a familiar, easy-to-navigate user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I directly pass data between two Microsoft Forms without third-party tools?

No, Microsoft Forms does not natively support transferring data from one form submission to automatically create or populate another. You must use Power Automate to bridge the data between the two forms.

How do I prepopulate a Microsoft Form?

You can prepopulate a Microsoft Form by enabling 'Get link to duplicate' or by constructing a custom URL that appends specific question parameters and values, which can then be dynamically filled using Power Automate.

Are there limits to using Power Automate with Microsoft Forms?

Yes, Power Automate has limitations based on your Microsoft 365 licensing plan, including API request limits, flow run frequencies, and data connector restrictions. Highly complex scenarios may require premium connectors.

Office Quick Solutions