Skip to main content

Notifications

Power Automate - General Discussion
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

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Sending Array Emails with Options

    @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. 

  • Flynnbags Profile Picture
    Flynnbags 2 on at
    Re: Sending Array Emails with Options

    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
    annajhaveri 8,531 on at
    Re: Sending Array Emails with Options

    @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?

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard