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 / Creating an array of e...
Power Automate
Answered

Creating an array of emails with excel table

(0) ShareShare
ReportReport
Posted on by 24

Hi,

So now I have the following flow. I have an excel table, with people emails and a number with their sales. I am sending an individual email to each if the value is higher than 0 for example.  


But instead of sending an individual email for each, I would like flow to go row by row, get the emails of the persons who have sales higher than 0 and send one unique email to this "array" of emails.


Is it possible?


Thanks

 

 

flow.png

Categories:
I have the same question (0)
  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @nailepmac 

     

    You could filter your list rows on the column you mention

    salevalue gt '0'

    Then use a create html table action with the value from this get items action

     

    Then create a string variable for the email list.

    An apply to each that takes the value from the list rows with....

    an append to string [dynamic email field] ;

     

    Finally a send email to string with the HTML table as your content?

     

    End result is everyone gets the same email with the table of sales greater than 0.

     

    Hope that is what you are looking for.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • nailepmac Profile Picture
    24 on at

    Could you please provide a flow example for the second part Damien (variable emails + append string etc) ? Still a newbie on flow...

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @nailepmac 

     

    I've done you a demo online here

     

    This is what the flow looks like:

    DamoBird365_0-1616174851821.png

    I was going to filter within the excel action but discovered that the sales values are returned as a string and you cannot therefore filter directly within the get rows action.  Don't worry though, we can use filter array and I have demo'd that in my video covering your requirements.

     

    Please let me know how you get on.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • nailepmac Profile Picture
    24 on at

    Simply PERFECT! 1000 "thank yous"! This is going to help me a lot in my work. Best wishes!

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard