Power Platform Community Forum Thread Details

Hello,

I would like to use Power Automate to send a series of emails that have a specific PDF file attached. The information for which email address needs which file is saved in a table in an Excel file, and the matching PDF files are in the same SharePoint folder (although I can move this to OneDrive if easier).

For example:

EmailAddress	FileName
persona@abc.com	File1.pdf
personb@abc.com	File2.pdf
personc@abc.com	File3.pdf

The end result will be around 1000 rows so automating it will be much more straightforward than emailing everyone and attaching the files one by one.

I would like to build a flow that emails persona@abc.com with the file File1.pdf attached, before looping and going down the column until everyone has been emailed. The file name in the second column of this Excel sheet matches a PDF file with the same name and is stored in the same folder as this Excel sheet.

I've managed to get it to work by fixing the PDF file, but not managed to get a dynamic file path to work. It feels like it should be straightforward but I am going round in circles - any help is appreciated!

Categories:

Building flows