Others

How to Send Emails to Multiple Comma-Separated Addresses in Power Automate

John Wilson Sep 27, 2026 869 views

Question details

The user needs a way to send automated emails to multiple comma-separated addresses entered in a form text field using Power Automate, avoiding the need to store the recipients in a SharePoint list.

How to Send Emails to Multiple Comma-Separated Addresses in Power Automate

Product: Power Automate
Device & OS: not provided
Scenario: Capturing multiple email addresses from a single form submission and delivering an automated notification to all specified recipients.
Observed behavior: The workflow must accurately split and validate the comma-separated string from the form platform (like Microsoft Forms) so the email action can correctly interpret the recipients.

Before you start

Determine the exact form platform you are using (e.g., Microsoft Forms or a custom SharePoint list form) to ensure you select the correct trigger action in Power Automate.

Solution 1Recommended

Split and Format Email Addresses in the Workflow

Use expressions in Power Automate to parse the single text string into an array of individual email addresses.

Power Automate's email actions require distinct, valid email addresses. When receiving a single string separated by commas, the workflow must be configured to split the text and trim any excess spaces before attempting to send the message.

Set Up Your Trigger

Create a new automated cloud flow and select the appropriate trigger for your form, such as 'When a new response is submitted' for Microsoft Forms.

Initialize a Compose Action

Add a 'Compose' action. In the inputs field, use the split() expression to separate the form's text field variable by commas: split(variables('YourTextField'), ',').

Trim Whitespaces (Optional but Recommended)

Add an 'Apply to each' loop using the output from the previous Compose action to use the trim() expression on each item, ensuring there are no leading or trailing spaces on the email addresses.

Configure the Email Action

Add the 'Send an email (V2)' action. In the 'To' field, switch to 'Enter custom value' and pass the formatted array or the properly joined string of email addresses.

Split and Format Email Addresses in the Workflow

Platform Specific Guidance: The exact implementation and expressions may vary depending on your form's data structure. For highly complex validation, consider consulting the Microsoft Power Platform Power Automate community.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite Alternative?

While Power Automate handles advanced workflows in the Microsoft ecosystem, if you need a highly compatible, lightweight, and cost-effective daily productivity suite, consider WPS Office.

1. Download the Installer: Visit the official WPS Office website to download the free, lightweight installer.
2. Install WPS Office: Run the setup file and follow the straightforward on-screen instructions to install the suite on your device.
3. Open Your Files Seamlessly: Double-click your existing Microsoft Office files to instantly open and edit them in WPS Office without any format conversion.

Completely free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Intuitive, all-in-one interface for seamless migration and daily office workBuilt-in PDF editing, document conversion, and secure local file management

microsoft office alternative - wps office

Frequently Asked Questions

Do I need to store the email addresses in a SharePoint list?

No. Power Automate can dynamically process the comma-separated text string directly from the form submission and pass it into the email action, bypassing the need for a SharePoint list.

What Power Automate expression splits a string?

You can use the split() expression to divide a single string into an array based on a delimiter. For example, split(triggerBody()?['EmailField'], ',') breaks the string at every comma.

Where can I get complex troubleshooting help for Power Automate?

The Microsoft Power Platform Power Automate community forum is an excellent resource for receiving platform-specific guidance, sharing flow logic, and solving complex validation issues.

Office Quick Solutions