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 Array Emails w...
Power Automate
Unanswered

Sending Array Emails with Options

(0) ShareShare
ReportReport
Posted on by 2

Hi All,

 

I have a scenario where i want to send briefings to various staff lists via email with options which are triggered from the creation of an item in Lists.

 

The basic way i want it to work is:

 

  • List item created
  • Any attachments to the item are added to the email (there may be multiple attachments to each item)
  • Email is sent to every email that has been included on the list item (there may be up to 300 email addresses per list item)
  • Email has two option buttons and users must pick one option (I understand or I need more information) 

 

I have managed to make it work with the Append to Spring Variable but this sends one email with every email address. This is fine except once one person clicks one of the options, the options are not available to any other recipients. 

 

What I think I need is to use Append to Array Variable so there is one email per email address but I can't seem to make it work in the same way as the string variable. 

 

My Current flow with the string variable is below.

 

First PartFirst PartSecond PartSecond Part

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Flynnbags  append to string variable logic seems to be fine in your flow, what issue are you facing exactly here, is it just getting one email address? Also what is the data type of the column in SharePoint list which stores user's emails?

  • Flynnbags Profile Picture
    2 on at

    Hi @annajhaveri ,

     

    The Data Type is as below:

    Flow 3.png

     

    The problem I'm having is that I need a response to the options from every person the email goes to. When i use the string, the first person to click an option is the only one who can answer, the options disappear for everyone else.

     

    In a nutshell, what I have now is one email sent to many users, whereas what I want to end up with is one email sent to each user individually so that each user can pick an option response.

     

    Thanks for your help,

    David

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Flynnbags  okay so if you want to send email individually to user, in that case, move the Send Email action  inside the Apply to each 4 action, instead of sending email to the all email address which are appended in Emails variable. 

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

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
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 820

#3
Haque Profile Picture

Haque 505

Last 30 days Overall leaderboard