web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / how to send multiple s...
Power Automate
Suggested Answer

how to send multiple select address email from excel using power automate

(0) ShareShare
ReportReport
Posted on by Community member 25
I’m working on automating a process in Power Automate to create individual emails for different markets. Each market has its own set of recipients and a specific attachment, but the email body remains the same across all.
 

Instead of sending these emails out directly, I want them to be saved in the Drafts folder — either in my own Outlook mailbox or a shared mailbox — so I can review and send them manually.

I’ve created a flow that loops through the data and generates emails, but I’m running into the following error:

Seems like it’s just the Select_To that’s not formatting the output the way the Graph API expects.
 
 

 

Draft email -.xlsx
Categories:
General topics
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,969 Moderator on at
     
    The schema is more like this, your to for instance is just you using the Node and then a list of emails but you haven't structured it as an array / object
     
    where within the toRecipients you would have multiple { emailAddress sections, each one with its own email}, thats not what you are producing.
     
    So you need to specifically make your toRecipients an [ ] and then on the inside create the structure properly. Same for cc also.
    you need it to look like and FYI my comma is to the far left and looks tiny hehe but its there in between instances
     
    [
    ,
    ,
    ]
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans