Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ler 72 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ricardorh00 2 on at

Like (0)

Report
Copy link

Link copied!

Hi. Using the exact same example, but instead of 1 column name pdf name, I have two columns. One named PDF Name and the other one named PDF Name2. Meaning, that I a need to send from an especific folder two different file to the same mails, meaning: 1 row = an email with two columns (two different files).
Can you please assist me with this?
Thanks!

Was this reply helpful? Yes No