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 / I want to send list of...
Power Automate
Answered

I want to send list of owners from previous out on an email

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have created a flow who's output has property "mail" it has email address of all office365 site owner

trigger

poojabaniya_1-1661257853526.png

 

output is below , similarly for rest of the owners as well i get below output, i want to send list of all owner in an email to user

Can someone please help how should I achieve it

poojabaniya_0-1661257665574.png

 

Categories:
I have the same question (0)
  • Verified answer
    MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @Anonymous ,

    if I have understood correctly your requirement, please follow these steps:

    1. Initialize a String variable:

    MarconettiMarco_0-1661272314488.png

    2. Send an HTTP request:

    MarconettiMarco_1-1661272356067.png

     

    3. Add a "Parse JSON" action:

    - Content: Body grabbed from previous action;

    - Schema: run the flow, copy the "Send an HTTP request" outputs and paste it in the "Generate from sample" section.

    MarconettiMarco_2-1661272377928.png

    4. Generate an "Apply to each" control, select the "value", grabbed from the "Parse JSON" action in the 2Select an output from previous steps" field:

    MarconettiMarco_4-1661272545938.png

     

    5. Within the "Apply to each" control, add an "Append to string variable" action, putting the "mail" value got from the "Parse JSON" action. I've appended the variable in the following way just to see in an easier way the email in the email body:

    - @{items('Apply_to_each')?['mail']}<br>

    6. Outside the "Apply to each" loop, add the Outlook "Send an email (V2)" action and put the variable in the email body:

    MarconettiMarco_5-1661272670427.png

     

    Here the full flow:

    MarconettiMarco_6-1661272710604.png

     

    Here the output:

    MarconettiMarco_7-1661272731758.png

    Please let me know if the issue is fixed.

    I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.


    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.


    My blog site about Power Automate: https://powerautomatejoy.com/

    BR,

    Marco

     

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank so much for taking efforts, I have tried but getting error while saving flow

    poojabaniya_0-1661433864624.png

     

  • Verified answer
    MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @Anonymous ,

    in the Append to string variable you should put the "mail" grabbed from the Parse JSON action and not the same variable:

    MarconettiMarco_0-1661434081543.png

     

    Please let me know if the issue is fixed.

     

    If I have answered your question, please mark my post as Solved.

    If you like my response, please give it a Thumbs Up.

     

    I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

     

    My blog site about Power Automate: https://powerautomatejoy.com/

     

    BR,

    Marco

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks a ton, this exactly I wanted

     

    Can you help me with one more thing

    I even wanted to email to this owners list for approval

    I have tried action trigger start and wait for approval  with trigger first one to respond

    still flow is not getting completed till all owners acknowledge it (approve/reject)

    is it a bug or I am doing something wrong

    poojabaniya_0-1661438968955.png

     

  • Verified answer
    MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @Anonymous ,

    you're more than welcome.

    When the flow is fired and arrives at "Start and wait for an approval" step, it will send the email to the approvers, and it remains in progress until one of the Approves or Rejects the request.

    So, if one of the Approvers takes action, then the run continues with the next actions.

     

    Please let me know if the issue is fixed.

     

    If I have answered your question, please mark my post as Solved.

    If you like my response, please give it a Thumbs Up.

     

    I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

     

    My blog site about Power Automate: https://powerautomatejoy.com/

     

    BR,

    Marco

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
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard