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

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

 

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard