Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by

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

 

  • Verified answer
    MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at
    Re: I want to send list of owners from previous out on an email

    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

  • Community Power Platform Member Profile Picture
    on at
    Re: I want to send list of owners from previous out on an email

    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
    Re: I want to send list of owners from previous out on an email

    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
    on at
    Re: I want to send list of owners from previous out on an email

    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
    Re: I want to send list of owners from previous out on an email

    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

     

     

     

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow