Populate an Outlook To Field Without Sending an Email in Power Automate
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.

- 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.
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.
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.
Open your Power Automate flow, navigate to the point after your SharePoint contacts are collected, and click 'New step'.
In the search bar, type 'Outlook draft' and select the 'Create a draft email (V2)' action under the Office 365 Outlook connector.
Click inside the 'To' field and use the Dynamic content menu to insert the email addresses you collected from SharePoint.
Add your desired text to the Subject and Body fields. You can also click 'Show advanced options' to add CC or BCC recipients.
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.

Generate a 'Mailto' Deep Link for Local Desktop Compose
If you strictly need a pop-up compose window to appear on your local machine, you can use Power Automate to generate a clickable link.
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. Visit the official website: Go to the official WPS Office website to access the secure download page.
- 2. Download the installer: Click the 'Free Download' button to download the lightweight installation file to your computer.
- 3. Install and launch: Run the downloaded installer, follow the simple on-screen instructions, and start using your new office suite immediately.

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.




