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 / Sending Email with All...
Power Automate
Answered

Sending Email with All Item Associated with the Respective Owner

(1) ShareShare
ReportReport
Posted on by 2

Hi,

 

I have a list with multiple items with their status and its respective owner. I want to send email a list of all the items which are belongs to a specific owner. Can anyone please guide that how can we achieve this?

 

Warm Regards,

Akshay 

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @AkshayManke 

    Here is a link to a solution that you should be able to use without much alteration assuming that your data source is SharePoint.

     

  • Verified answer
    David- Profile Picture
    1,254 on at

    I think I understand what you are looking for, and if so this may work. After your Get items action, initialize an array variable to capture the e-mail address of the owner. Then use an Apply to each to append the e-mail address to the array. This will probably result in duplicates, but that is okay at this point.

    David_0-1659363678704.png

    After the Apply to each action Initialize another array variable and use the union expression to get just the unique e-mail addresses. Expression: union(variables('Submitters'),variables('Submitters'))

    David_1-1659363734094.png

    Next, add another Apply to each action with the output of the Above variable (Emails). In the apply to each add a Compose action that contains the current item as the input. Next add a Get items action and filter the e-mail address of your owner with the output of the Compose action. I then add another Compose action to get the length of the Get items action to make sure it found items. Then I use a condition if the count is greater than 0 continue.

    David_2-1659363996076.png

    In the condition, use a Select action to get the fields you want to send in the e-mail, followed by a Create HTML table from the Select action. You can then insert the HTML table into your e-mail.

    David_3-1659364114459.png

    The end result is:

    David_4-1659364260980.png

    Hopefully this makes sense... 🙂

  • AkshayManke Profile Picture
    2 on at

    Hello @David- and @ScottShearer,

     

    Apologies, it took more time to get back to you with the testing results. Created a combination of both suggestion and the same is working satisfactory. Thanks for the help!!! 

     

    Warm Regards,

    Akshay

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

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard