cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amirattia12
Regular Visitor

mail merge flow with unique attachment

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
amirattia12
Regular Visitor

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

View solution in original post

1 REPLY 1
amirattia12
Regular Visitor

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

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,265)