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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending email based on...
Power Automate
Answered

Sending email based on multi-select column in SharePoint list

(0) ShareShare
ReportReport
Posted on by

Hello all,

 

I am having trouble figuring out how to get my flow to only send one email regardless of how many choices are selected in a multi-select choice column in a SharePoint list. As is, the flow sends out an email per choice selected (for example: if 5 choices were selected in the column then 5 emails would send, each showing one of the choices)

 

I have already figured out how to concatenate the choices in the email (or at least I assume I did cause it's working) but I am still missing the key part to make it send as one email. 

 

Any help is greatly appreciated. Or critiques/tips on what I already have set up. (I know it's probably messier than it needs to be)

 

Thanks!

Annotation 2023-03-20 142734.png
Annotation 2023-03-20 142835.png
Annotation 2023-03-20 142932.png
Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @Becca_Hayes ,

     

    Your send email action should be outside the loop.

    Inside the loop:

    Add all the selected Technology values in an array

    Then, outside the loop:

    Check the length of the array, if it is greater than one, send an email.

  • Verified answer
    v-dezhili-msft Profile Picture
    Microsoft Employee on at

    Hi @Becca_Hayes ,

     

    Please try:

    vdezhilimsft_0-1679377241858.png

    vdezhilimsft_2-1679377323233.png

    vdezhilimsft_1-1679377282093.png

    vdezhilimsft_3-1679377355213.png

    vdezhilimsft_4-1679377404102.png

     

    Best Regards,

    Dezhi

     

     

     

     

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 227 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 213 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 151

Last 30 days Overall leaderboard