How to Route New Starter Vendor Requests Using Microsoft Forms and Power Automate
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.

- 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.
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.
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.
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.
Log into Power Automate, click 'Create' on the left menu, and select 'Automated cloud flow'.
Name your flow and select the trigger 'When a new response is submitted' under Microsoft Forms, then select your specific form from the dropdown.
Add a new step, search for 'Get response details', and link it to your Form ID and the Response ID generated by the trigger.
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.
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.
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.

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. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation prompts.
- 2. Open Your Documents: Launch WPS Office and open any existing Microsoft Office files (.docx, .xlsx, .pptx) without formatting loss.
- 3. Manage Onboarding Materials: Use WPS Writer and Spreadsheet to maintain new starter records, vendor lists, and tracking sheets efficiently.

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.




