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 flow with u...
Power Automate
Unanswered

mail merge flow with unique attachment

(0) ShareShare
ReportReport
Posted on by 15

Hi Everyone,

 

I really need your help in order to setup an automated process through flow. I really think that this could be done through ms flow, but I can’t make it happen so far. As I am not an experienced user any suggestions are welcome and appreciated.

 

Target.

send more than 1K pdf's , 1 file to one unique email

 

my understanding is :

like mail merge. 

I got excel sheet with all my dynamic content for the email with file name in each row 

FileemailinfoIDNameSurname
Maiskffir@email.com 11MaiElbeltagy
Nadinedjdsdkdsv@email.com 13NadineBahgat

 

PDF files are saved on Onedrive in a folder

 

What I achieved so far:

I could make a flow to send all emails with dynamic content to all recipients with one file using "Get File Content" 

tried different things but i end up with sending all files that are on Onedrive to all recipients

 

I need help with making the flow to send 1 file only to each row in my excel sheet. 

Thank You 

 

my flow.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    amirattia12 Profile Picture
    15 on at

    Hi Everyone, 😀 

    I managed to get it after a lot of research here on this forum, 

    and after 52 or more trial and fails runs 

    I'll post my final flow here for anyone who might need it in the future, 

    Many Thanks to you all 

     

    😀

    Step 1 - Flow.pngStep 2 - Flow.pngStep 3 - Flow.pngStep 4 - Flow.pngFinal Flow.png

  • cwijayd Profile Picture
    2 on at

    Hi, 

    I am trying to do the same, send email to hundred people own attachments.

    I manage to follow the step, but I don't know why at the end my flow not RUN, the icon RUN I grey while the others are blue. 

     

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