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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiple Email ID in a...
Power Automate
Answered

Multiple Email ID in array

(1) ShareShare
ReportReport
Posted on by 301

How do I extract only email ids from the array of collected emails from which I got from parson as json action to get group's member email ids
I'm new to flows.

email.png
Categories:
I have the same question (0)
  • Verified answer
    trice602 Profile Picture
    15,886 Super User 2025 Season 2 on at

    Hi @apeawakening ,

     

    Great job on your flow!  If you are already using parse json then you are in pretty good shape.  Here is the next step.  In this example, I have used parse json action to exposure my datapoints.  In this example, I don't have "email" as one of the fields but you will use "Email" from your dynamic content in Parse Json action.

     

    trice602_0-1696951333717.png

     

     

    So, imagine for a minute in the below example where "id" would be "email".  This is what your Send email action would look like.  In your apply to each, for each email, we send an email.  (ignore the get file content below, from a different example).

     

    trice602_1-1696952023353.png

     

  • Michael E. Gernaey Profile Picture
    53,928 Super User 2025 Season 2 on at

    @apeawakening 

     

    Assuming that the value you put in the From is an array lets do this.

     

    I have made an example.

    Before the Send Email Action (remember above it)

    1. Add a Select Action

    2. in the From, add the value that you had added to the To Email line. In my case its a variable I made up to look like your array of Email addresses

    3. in the Select, there is a little Icon next to the end of the Map input. Click it to turn into advanced mode. The icon you see blow is what I mean

    FLMike_2-1696952469573.png

     

    4. once the advanced mode comes up, click in the Box to set the value. When the Popup window appears, click on the Expression Tab and type this

    item()['Email']

    And click ok. You will see the below, EXCEPT that your From should show your value as I asked you to place there

    FLMike_1-1696952460866.png

     

     

    5. Under the Select Action, I want you to add a Compose action

    -When you in the input box, the Popup window appears. In the Expression tab type or copy and paste mine

    replace(join(body('Select'),','), ',', ';')

     

    6. In your Send email. Remove the current Value you have for the To.

    -Click the To Input box so that the PopUp window appears

    But this time, on the Dynamic Content Tab (the first one), you will see the Dynamic Property called Outputs, under your Compose, click that

    FLMike_3-1696952613994.png

     

    Important NOTE: If you have already used a Select or a Compose, then the Names will be different, so you need to update the expressions I gave you to those names.

     

    Example: In my expression I say body('Select'), but if you already had a previous Select, then you need to get the Name from the New Select title bar and replace Select, with that. Also remember if there are Spaces like Select 2, you need to type it like this Select_2 because spaces arent valid in an expression


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • Ape Awakening Profile Picture
    301 on at

    I was already using parse json , so basically I have add apply to each for mail to each user

  • Michael E. Gernaey Profile Picture
    53,928 Super User 2025 Season 2 on at

    @apeawakening 

    But do you want to send the same email to them all at once (which is what mine does), or do you want to send individual emails of the same thing to different people?


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Ape Awakening Profile Picture
    301 on at

    I tried replace with it didnt workout

  • Michael E. Gernaey Profile Picture
    53,928 Super User 2025 Season 2 on at

    @apeawakening  I would have to see your code, as it worked fine for me with your exact data

     

  • Ape Awakening Profile Picture
    301 on at

    Here is my flow 

    flow.png
  • Michael E. Gernaey Profile Picture
    53,928 Super User 2025 Season 2 on at

    Hi @apeawakening 

     

    I am referring to the two steps you would have added if you tried mine. But you went the other direction so its all good.

     

    Cheers,

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard