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 / SharePoint list flow o...
Power Automate
Suggested Answer

SharePoint list flow on item creation sending multiple emails

(0) ShareShare
ReportReport
Posted on by
I have a SharePoint list that is used for setting up measures for floor coverings. There are five Area dropdown fields that a user can select multiple areas per material you are measuring for.  I'm building this to replace an InfoPath forms library that worked wonderfully.  Now when if you select more than on item in the area field the flow sends one email per selection, not an ideal solution.  How can I gather the dropdown info and get it into one email?  
Categories:
I have the same question (0)
  • Suggested answer
    SebS Profile Picture
    4,826 Super User 2026 Season 1 on at

    What is probably happening is the email action has ended up inside an Apply to each because Power Automate sees the Area values as an array.

    I’d build the Area text first, then use that in the email.

    Add a Select action before the email:

    From

    Area

    Map the value as:

    item()?['Value']

    Then add a Compose action after it:

    join(body('Select'), ', ')

    Use the Compose output in the email body.

    The key bit is to make sure Send an email is outside the Apply to each. The flow should be more like:

    Trigger / Get item
    Select Area values
    Compose joined Area values
    Send one email

    Not:

    Apply to each Area
        Send email

    That should give one email with all areas listed, for example:

    Reception, Corridor, Office, Store Room
  • Suggested answer
    JL-18051311-0 Profile Picture
    2 on at
    Thanks for the info. However, after discussion with the client, we decided to change the Area field from a dropdown to a text field to fix the issue.

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard