Others

How to Send Microsoft Forms Responses to Multiple Email Recipients with Power Automate

Guest Writer Oct 12, 2026 868 views

Question details

The user needs to trigger an email to multiple selected recipients based on a Microsoft Forms submission using Power Automate, requiring a way to properly combine and format the email addresses.

Send Microsoft Forms Responses to Selected Email Recipients with Power Automate

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Creating a Power Automate flow that takes an array of selected email addresses from a Microsoft Form submission and sends an automated email to all of them.
Observed behavior: When multiple recipients are selected in the form, the raw output must be properly combined into a valid, semicolon-separated recipient list before the email action can execute successfully.

Before you start

Ensure you have active licenses for both Microsoft Forms and Power Automate, and that your form includes a multiple-choice question designed to collect or select valid email addresses.

Solution 1Recommended

Use the Join Action to Format Multiple Email Addresses

Use the Join function in your Power Automate flow to combine multiple selected email addresses from a form into a semicolon-separated string, which is the required format for sending emails.

When a form collects multiple email addresses, the data is often returned as a JSON array. The 'Send an email (V2)' action requires multiple email addresses to be separated by semicolons. Adding a Join action ensures the array is properly converted into a valid recipient string.

Set up the trigger and get response details

In Power Automate, create an automated cloud flow with the trigger 'When a new response is submitted'. Add the 'Get response details' action and select your Form ID.

Add a Compose or Join action

Add a new step before your email action. Search for 'Compose' under Data Operations.

Apply the Join expression

Click inside the Inputs field of the Compose action, switch to the Expression tab, and enter: join(json(outputs('Get_response_details')?['body/xxxx']), ';') — replacing 'xxxx' with the specific question ID from your form.

Configure the Send an email action

Add the 'Send an email (V2)' action. In the 'To' field, insert the dynamic 'Outputs' from the Compose action you just created. Leave the 'Send As' field blank unless your account has specific Exchange permissions.

Use the Join Action to Format Multiple Email Addresses

Send As Permissions: You do not need to configure 'Send As' permissions for standard functionality. The email will automatically send from the flow owner's account. If you do attempt to use 'Send As', the account must explicitly have 'Send As' or 'Send on behalf' permissions configured in Exchange.

Free Microsoft Office alternative

Discover WPS Office for Your Daily Document Needs

While Power Automate handles your complex cloud workflows, WPS Office is an excellent, free alternative for managing your daily documents, spreadsheets, and presentations. Enjoy a familiar interface and seamless compatibility with Microsoft file formats without the heavy subscription fees.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats (.docx, .xlsx, .pptx).Lightweight application that loads instantly and saves system resources.Built-in robust PDF editing toolkit for all your document processing needs.Familiar user interface that requires zero learning curve for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Power Automate flow failing when sending to multiple recipients?

Power Automate's email actions require multiple email addresses to be separated by semicolons (;). If your Microsoft Form provides the emails in an array or separated by commas, the action will fail. You must use a Compose action with the `join` expression to reformat the list.

Do I need special Exchange permissions to send automated emails?

Not usually. By default, Power Automate sends the email from the account that established the Outlook connection in the flow. You only need special Exchange permissions if you are trying to populate the 'Send As' field to send emails on behalf of another user or a shared mailbox.

Can I send form responses to both internal and external users?

Yes. As long as the selected email addresses are valid and formatted correctly using semicolons, Power Automate can send the automated email to anyone, regardless of whether they are internal to your organization or external users.

Office Quick Solutions