Others

How to Send Personalized Microsoft Forms Surveys with Power Automate

Steve K Oct 1, 2026 869 views

Question details

The user wants to automate sending personalized Microsoft Forms surveys using Power Automate and Power BI, specifically passing ticket details into the form.

How to Send Personalized Microsoft Forms Surveys with Power Automate

Product: Power Automate, Microsoft Forms
Device & OS: not provided
Scenario: Automating survey distribution to specific users after a ticket is resolved, with prefilled ticket information.
Observed behavior: Needs a systematic way to identify recipients, construct a prefilled Microsoft Forms link with ticket details, and send the customized survey via automated flow.

Before you start

Ensure you have active licenses for Microsoft Forms, Power Automate, and Power BI, and that your source data (like recipient emails and ticket numbers) is structured properly.

Solution 1Recommended

Use Power Automate to Send Prefilled Microsoft Forms Links

Create an automated workflow that dynamically replaces variables in a prefilled form link with actual ticket details before emailing the recipient.

To accomplish this, you must first generate a prefilled URL template from your Microsoft Form. Power Automate will then insert the dynamic content (like the ticket number) into this URL and email it to the target user.

Generate a prefilled link in Microsoft Forms

Open your Microsoft Form, click the three dots (More form settings) in the top right corner, and select 'Get prefilled link'. Fill in dummy data for the fields you want to personalize (e.g., enter 'TICKET123' in the Ticket Number field), then click 'Get link' and copy the URL.

Set up your trigger in Power Automate

Log into Power Automate and create a new automated cloud flow. Choose a trigger that matches your scenario, such as 'When a Power BI button is clicked' or when a new row is added to your ticketing database.

Construct the dynamic URL

Add a 'Compose' action in your flow. Paste the prefilled link you copied earlier. Locate your dummy data ('TICKET123') in the URL text and replace it with the dynamic content variable for your ticket number from the previous step.

Configure the email action

Add a 'Send an email (V2)' action. Insert the recipient's dynamic email address in the 'To' field. In the body of the email, add your survey message and insert the outputs from your 'Compose' action as the hyperlink for the survey.

Test your flow

Save and test the flow to ensure the email is sent properly and that the dynamically generated link correctly prefills the ticket number when clicked by the recipient.

Use Power Automate to Send Prefilled Microsoft Forms Links

Limitation Warning: Prefilled values in Microsoft Forms are visible and editable by respondents. Ensure your flow accounts for this, or securely store the ticket number against the recipient's email in your database instead of passing it purely via the URL.

Free Microsoft Office alternative

Looking for a Lightweight Office Alternative? Try WPS Office

While Power Automate and Microsoft Forms handle complex enterprise workflows, WPS Office is an excellent free, lightweight alternative for your daily document, spreadsheet, and presentation tasks. It offers a highly familiar interface and robust format compatibility.

1. Visit the WPS Website: Go to the official WPS Office website to access the free download.
2. Download the Installer: Click 'Download WPS Office Free' and save the installation file to your device.
3. Install and Start Creating: Run the installer, follow the on-screen prompts, and launch the suite to start opening and editing your Office files instantly.

Fully compatible with Microsoft Word, Excel, and PowerPoint formatsFree and lightweight suite perfect for everyday productivityIncludes WPS Forms for quick and simple data collection needsFamiliar user interface requiring zero learning curve for easy migration

microsoft office alternative - wps office

Frequently Asked Questions

Can respondents edit the prefilled fields in Microsoft Forms?

Yes, Microsoft Forms currently allows respondents to see and edit any prefilled information. If strict data integrity is required, it is better to track responses using the recipient's email address and correlate it with your database on the backend.

How do I trigger this flow directly from Power BI?

You can add a 'Power Automate for Power BI' visual directly into your Power BI report. This allows you to pass context data (like selected user emails and ticket numbers) straight into a Power Automate flow by clicking a button in your dashboard.

Is there a limit to how much data I can pass in a prefilled link?

Yes, URLs have a strict character limit, typically around 2,000 characters depending on the browser. Always keep the prefilled data brief, such as passing just a unique Ticket ID rather than full paragraphs of text.

Where can I get advanced help for building this flow?

For highly specific implementation guidance, Microsoft maintains active communities at community.fabric.microsoft.com for Power BI and powerusers.microsoft.com for Power Automate.

Office Quick Solutions