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 / mail merge flow with u...
Power Automate
Answered

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

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 630

#2
Valantis Profile Picture

Valantis 420

#3
11manish Profile Picture

11manish 350

Last 30 days Overall leaderboard