Others

How to Route New Starter Vendor Requests Using Microsoft Forms and Power Automate

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

Question details

The user wants to collect new employee onboarding data and automatically route the submissions to specific support vendors while notifying the office manager.

How to Route New Starter Vendor Requests Using Microsoft Forms and Power Automate
Product
Microsoft Forms and Power Automate
Device & OS
not provided
Scenario
Automating the onboarding process to route submitted new-starter forms to correct vendors based on form input selections.
Observed behavior
Microsoft Forms natively lacks the ability to route responses to different users conditionally, requiring Power Automate to handle conditional logic and notifications.
Before you start

Ensure you have an active Microsoft 365 subscription with access to both Microsoft Forms and Power Automate, and prepare the list of your vendor contact emails beforehand.

Solution 1Recommended

Create a Power Automate Flow for Vendor Routing

Build a custom automated cloud flow that triggers upon form submission to route data to different vendors conditionally.

Microsoft Forms alone does not provide an out-of-the-box way to route responses to different vendors based on the answers provided. By integrating it with Power Automate, you can extract the submitted data and apply a Switch or Condition control to send targeted emails to the right vendor.

1
Create your onboarding form

In Microsoft Forms, design your new starter form, making sure to include a multiple-choice question that asks which support vendor is required for the new employee.

2
Start an automated cloud flow

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

3
Set the trigger

Name your flow and select the trigger 'When a new response is submitted' under Microsoft Forms, then select your specific form from the dropdown.

4
Get response details

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

5
Add a conditional switch

Add a new step and search for the 'Switch' control. Set the 'On' field to the dynamic content of your vendor selection question. Create a case for each possible vendor choice.

6
Configure vendor emails

Inside each Switch case, add a 'Send an email (V2)' action addressed to the specific vendor. Insert dynamic content from the form to provide the vendor with the necessary starter details.

7
Notify the office manager

After the Switch block completes, add a final 'Send an email (V2)' action to notify the office manager that the vendor routing has been processed successfully.

Create a Power Automate Flow for Vendor Routing
Test Your Flow: Always submit a test response in your Microsoft Form to verify that the dynamic data maps correctly and emails are successfully routed to the intended vendor and office manager.
Free Microsoft Office alternative

Experience a Lightweight, Fully Compatible Office Suite

While Power Automate handles advanced Microsoft ecosystem workflows, WPS Office provides an outstanding free alternative for handling your everyday documents, spreadsheets, and presentations. It offers seamless compatibility with Microsoft formats, making it perfect for processing vendor contracts, starter lists, and onboarding documentation.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation prompts.
  2. 2. Open Your Documents: Launch WPS Office and open any existing Microsoft Office files (.docx, .xlsx, .pptx) without formatting loss.
  3. 3. Manage Onboarding Materials: Use WPS Writer and Spreadsheet to maintain new starter records, vendor lists, and tracking sheets efficiently.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with fast startup times for daily administrative tasks.Includes built-in PDF editing tools for managing vendor contracts securely.Familiar user interface makes transitioning easy for office managers and new starters.
QA img-9

Frequently Asked Questions

Can Microsoft Forms send email notifications to different people without Power Automate?

No, Microsoft Forms natively only sends basic email receipts to the form creator or the respondent. Conditional routing based on form answers requires a Power Automate flow.

What is the difference between a Condition and a Switch in Power Automate?

A 'Condition' checks if a specific statement is true or false, making it best for two routing options. A 'Switch' evaluates a single variable and can route the flow into multiple different paths, which is ideal if you have three or more vendors.

Do vendors need a Microsoft account to receive the routed information?

No. The 'Send an email (V2)' action in Power Automate can deliver the formatted onboarding details to any valid email address, regardless of the vendor's email provider.

How do I attach the form response as a PDF to the vendor email?

You can use the 'Populate a Microsoft Word template' action or the OneDrive 'Convert file' action within your Power Automate flow to generate a PDF from the response data, and then add it to the attachments section of the email action.