Others

Populate an Outlook To Field Without Sending an Email in Power Automate

Huda QurayshiHuda Qurayshi Nov 2, 2026 869 views

Question details

The user needs a way to populate the 'To' field of an Outlook email with contact addresses collected from SharePoint via Power Automate, but without triggering the email to send automatically.

How to Populate an Outlook To Field Without Sending an Email in Power Automate
Product
Power Automate, Microsoft Outlook
Device & OS
not provided
Scenario
Automating email preparation from a SharePoint contact list where manual review of the email is required before sending.
Observed behavior
Standard Outlook actions in Power Automate automatically send the generated messages instead of opening an unsent compose window with pre-filled fields.
Before you start

Verify that your Power Automate environment has active, authenticated connections to both SharePoint and Office 365 Outlook, and ensure you have the necessary permissions to read the contact list.

Solution 1Recommended

Use the 'Create a draft email' Action in Power Automate

This solution generates an email in your Outlook Drafts folder with the 'To' field pre-populated, allowing you to review and send it manually.

Because Power Automate runs in the cloud as a background service, it cannot physically open a compose window on your local computer's screen. However, it can seamlessly generate a draft email in your Outlook account.

By using the 'Create a draft email' action, the email is fully populated with your SharePoint contacts and saved safely in your Drafts folder for final review.

1
Add a new step to your flow

Open your Power Automate flow, navigate to the point after your SharePoint contacts are collected, and click 'New step'.

2
Search for the Outlook Draft action

In the search bar, type 'Outlook draft' and select the 'Create a draft email (V2)' action under the Office 365 Outlook connector.

3
Populate the 'To' field

Click inside the 'To' field and use the Dynamic content menu to insert the email addresses you collected from SharePoint.

4
Fill in the Subject and Body

Add your desired text to the Subject and Body fields. You can also click 'Show advanced options' to add CC or BCC recipients.

5
Save and test the flow

Save your flow and run a test. Open your Outlook application, go to the Drafts folder, and you will see the pre-populated email ready for manual sending.

Use the 'Create a draft email' Action in Power Automate
Reviewing Drafts: Drafts sync across all devices connected to your Outlook account, meaning you can review and send the email from your desktop, web browser, or mobile app.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Power Automate handles your background workflows in the Microsoft ecosystem, you still need a fast, reliable desktop suite for processing your exported data, reports, and daily documents. WPS Office provides a lightweight, comprehensive alternative to Microsoft Office that is fully compatible with Word, Excel, and PowerPoint formats—without the expensive subscription fees.

  1. 1. Visit the official website: Go to the official WPS Office website to access the secure download page.
  2. 2. Download the installer: Click the 'Free Download' button to download the lightweight installation file to your computer.
  3. 3. Install and launch: Run the downloaded installer, follow the simple on-screen instructions, and start using your new office suite immediately.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight application that opens large files quickly and runs smoothly on most devices.Familiar, intuitive tabbed interface that requires almost zero learning curve.Free essential features to edit, manage, and collaborate on your documents effortlessly.
microsoft office alternative - wps office

Frequently Asked Questions

Can Power Automate open a pop-up window on my computer?

No, Power Automate cloud flows run on remote servers in the background. They cannot interact directly with your local desktop UI to open a compose window. Generating a draft or a mailto link are the best workarounds.

How do I add multiple email addresses from SharePoint into the Outlook draft 'To' field?

You need to use a 'Select' action or an 'Initialize variable' action to extract the email addresses from the SharePoint array, followed by a 'Join' action to combine them into a single string separated by semicolons (;), which you then insert into the 'To' field.

Does the 'Create a draft email' action support attachments?

Yes. If you click 'Show advanced options' inside the 'Create a draft email (V2)' action, you can add attachments by providing the attachment name and the file content, just like you would with the standard 'Send an email' action.

Why did my Power Automate flow send the email instead of saving a draft?

You likely used the 'Send an email (V2)' action by mistake. To ensure the email is only saved and not sent, you must specifically search for and select the 'Create a draft email (V2)' action.