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 / Mail Merge with Power ...
Power Automate
Unanswered

Mail Merge with Power Automate: Bugs and questions

(0) ShareShare
ReportReport
Posted on by

Hi all,

 

I am trying to send individual PDF documents to a list of people. Below is the table with recipient details:

saskia_g_0-1681789026029.png

The files that I want to attach to each individual is named their name.pdf, i.e., the file for Emma is named Emma.pdf, which removes the "filter array" function from my flow.

 

My flow works, in the sense that it sends each person their personalized attachment, however, I as the sender also receive the 6 emails. I feared that my recipients also received multiple emails with others' attachments, but they didn't. I believe this is because the 'send email' function is in a loop within a loop, so for every iteration, it sends me an email as well. I don't fully grasp this logic. Is anyone able to look at my flow and let me know if there is a way I can send these attachments without receiving them in my inbox? My final spreadsheet has about 200 staff members with 200 personalized attachments, so I do not want to mess this up!

 

Below is my flow:

saskia_g_2-1681789232901.png

 

saskia_g_3-1681789274703.png

 

Categories:
I have the same question (0)
  • v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi @saskia_g ,

     

    According to the flow in the picture, the To property of "Send an email" is the email addresses in Excel. This flow will send an email to each of these 6 email addresses from your mailbox. So you can see in your email that you have sent 6 emails. What does it mean that you, as the sender, will also receive 6 emails?

     

     

     

    Best regards,

    Habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard