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

Take emails from a table in excel, and send an email with a specific PDF attachment to each one.

Hi there,

 

I have an excel table with a trader name, email, number and PDF name, and I'd like to send each trader in the list an email with their specific PDF.  At the moment, I've got all of the PDFs in a specific Onedrive folder.

 

Screenshot 2021-01-25 at 10.37.05 PM.png

 

I've tried a few different flows, but I can't get it to work. So far I manually trigger a flow, which then lists the files in the folder. I've then got an action to "List rows present in a table". I was hoping to use an array filter to then match them, and send an email for each row of the excel table, with the correct attachment. But this isn't working. 

 

Does anyone have any ideas? Thank you!!Screenshot 2021-01-25 at 10.40.45 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Ler
Advocate I
Advocate I

hi JoeBabbage

 

that is easy to do that, but my English is not well, hope it helps like below:

 

1. put all files you want to send in one folder (excel file should not in this path)

2. use list files from this folder (One Drive)

3. list rows present in a table (the PDF name in rows should like "1.pdf" not "1")

4. one loop for excel, in this loop create new loop for files

the loops will do the action one by one line.

when the list of files name = PDF name from rows, send mail V2

that is working for me. i try to mark the point part to English.

screenshot.png

 

View solution in original post

2 REPLIES 2
Ler
Advocate I
Advocate I

hi JoeBabbage

 

that is easy to do that, but my English is not well, hope it helps like below:

 

1. put all files you want to send in one folder (excel file should not in this path)

2. use list files from this folder (One Drive)

3. list rows present in a table (the PDF name in rows should like "1.pdf" not "1")

4. one loop for excel, in this loop create new loop for files

the loops will do the action one by one line.

when the list of files name = PDF name from rows, send mail V2

that is working for me. i try to mark the point part to English.

screenshot.png

 

View solution in original post

JoeBabbage
Regular Visitor

Thank you very much, that works great!! I really appreciate the help!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,290)