
Hi,
I'm trying to build a flow that sends an email to several addresses from an excel file. I've managed to use the variable union() to gather all vendor mails, but cannot do the same with attachments, which have the name vendorid.pdf
| VENDOR ID | SUPPLIER NAME | DESCRIPTION | VENDOR EMAIL |
| 123 | ABC, LLC | XYZ | vendorabc@domain.com |
| 123 | ABC, LLC | XXD | vendorabc@domain.com |
| 133 | CBD, LLC | XVY | vendorcbd@domain.com |
On the same shared folder I have
123.pdf
123.pdf
133.pdf
This is how I filter all emails as one.
Is there a way to send to each vendor, each corresponding pdf? Should I structure my table in a different way?
Thanks!
Hi @ElisaB
Could you please tell me:
Where are your pdf files saved?
Do you want to find the corresponding PDF and send an email based on the deduplicated Excel data?
I'm assuming your PDF files are saved in OneDrive.
I have made a test for your reference:
1.
2.
3.
4.
5.
Best Regards,
Levi