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 / Duplicate emails being...
Power Automate
Answered

Duplicate emails being sent to users with multiple tasks

(0) ShareShare
ReportReport
Posted on by 12

The flow I am working on is pictured. I am experiencing that when a user has multiple tasks, they are getting duplicate emails, and I am unsure of how to fix this. Am I missing a step that eliminates the duplicates being sent? Thank you in advance

Screenshot 2024-06-17 112258.png
Screenshot 2024-06-17 112351.png
Categories:
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @z_prins It's hard to say without seeing your actions expanded. Could you click on each action and expand it and upload a screenshot of your flow with all actions expanded?

     

    In the meantime, I cover how to send multiple SP items in a single email in this YT Tutorial: 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

     

    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
  • z_prins Profile Picture
    12 on at

    @creativeopinion here are the expanded views, Compose - CSS is just the formatting for the HTML with the dynamic content added at the end to populate. Email utilizes dynamic content to populate the subject line and body for a qty of open tasks and the person receiving the email and the HTML table.

    Screenshot 2024-06-17 125844.png
    Screenshot 2024-06-17 130015.png
    Screenshot 2024-06-17 130043.png
  • z_prins Profile Picture
    12 on at

    @creativeopinion here is the last picture of the email layout. Thank you for any help.

    Screenshot 2024-06-17 130137.png
  • Verified answer
    creativeopinion Profile Picture
    10,508 Moderator on at

    @z_prins The logic of your flow needs to be adjusted. You need to first create a list of unique users. I cover how to do that in this section of the tutorial.

     

    Using the union() function on the output of your Select action as you've done here is incorrect. The Select action is outputting the Name, Task, Due Date and Title of each of your SP items from the Get Items action in your flow. 

     

    Unless you have duplicate items (with the same Name, Task, Due Date and Title) — the union() function isn't really doing anything here. You need to Select the Users only. Then with the union() function create an array of unique users to loop through.

    creativeopinion_0-1718652558567.png

    This Apply to Each action should be looping through each unique user. Currently it's looping through each item in your SP list.

    creativeopinion_1-1718653294624.png

    Hope this helps!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard