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 / Email SharePoint List ...
Power Automate
Unanswered

Email SharePoint List items together in one email

(1) ShareShare
ReportReport
Posted on by 8

I have been able to get most of it done. The only issue Im having is ALL items from the list are being emailed individually instead of having all items in the list sent in one email. 

This is what the email looks like below (Body of email) Its listing the same item multiple times instead of listing all the items in one email. 

BlueApe57_0-1717252208129.png

 

This is what the list looks like. The goal is to have all those items listed on a single email 

BlueApe57_1-1717252297246.png

 

This is what the flow looks like ... not sure what needs to be changed

BlueApe57_2-1717252374844.png

 

 

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @BlueApe57 You might find these YT Tutorial helpful: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

     

    IN THIS VIDEO:

     How to send multiple list items in a single email with a Power Automate Flow

     How to create a dynamic date range

     How to use the Convert Time Zone action

     How to use a Filter Query in the Get Items action

    How to count number of items in an array

     How to use the Select action to extract a users display name and email address

     How to create a unique list of email addresses

     How to use the Create HTML Table action

     How to customize the HTML Table with CSS styles

    How to use the Send an email (V2) action

    How to use the Append to String Variable action

    How to create a custom list of items for an email

    How to use the Send an email (V2) action

    How to display singular or plural text based on the number of items returned

     

    If you still have issues with your flow after watching the tutorial, upload screenshots of your flow so I can help troubleshoot. 

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • BlueApe57 Profile Picture
    8 on at

    Instead of sending one email with all the tickets in the same email. Is sending in this case 5 separate emails with the same ticket repeated multiple times. See attached screenshots 

     

    BlueApe57_0-1718975425812.png

    BlueApe57_1-1718975480129.png

     

  • BlueApe57 Profile Picture
    8 on at

    Here is the flow: 

    BlueApe57_0-1718975936315.png

     

    BlueApe57_5-1718976120384.png

     

     

     

    BlueApe57_1-1718975980403.png

     

    BlueApe57_2-1718976005578.png

    BlueApe57_3-1718976028540.png

    BlueApe57_4-1718976080012.png

     

     

     

     

  • BlueApe57 Profile Picture
    8 on at
    Flow was posted. Any ideas how I can fix the duplicate list items in multiple emails instead of all list items going together in the same email???? 

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 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard