Hi!
I have the following automation process through a third party software that I was hoping I could make it work with flow:
I have an Excel spreadsheet in which I input a File Name, an E-mail, a Subject and a Message. The File is PDF and stored in a specific OneDrive folder.
I have the software read the spreadsheet and send e-mails using Outlook - it reads the first line, starts a new message, populates the e-mail using the information from the lines "E-mail", "Subject" and "Message" and find the File in OneDrive (always the same folder) to send as an attachment.
When I was trying to build a flow, I could not get past the first part - I was able to have Microsoft Flow send the e-mail, populating the fields with the spreadsheet information quite easily, but I do not seem to be able to add the PDF attachment to each specific message. Is there a way to do this?
It is a different PDF for each message (which has a different e-mail address as well - all coming from the excel spreadsheet)
Solved! Go to Solution.
Hi @victornabreu ,
If you can get the name of the file, then you can get the file content and send it as an attachment.
Image reference:
Best Regards,
Hi @victornabreu ,
Could you share a screenshot of your currently configured Flow?
It seems you want to get the filename of the PDF and email address from the Excel table.
I'm afraid I don't quite understand what the first part you mentioned is. Please provide more details.
Best Regards,
Hello, thank you for the response!
Yes, I want to get the file name from the Excel spreadsheet and have Microsoft Power Automate search for this file name within a designated OneDrive folder and attach this file to an Outlook message - which will be populated using other info from the same row in excel (e-mail, subject and message).
I tried building a flow, but ended up deleting it.
It went like this: button activated - get rows - for each row, send e-mail - use the info from the row and send.
But I wasn't able to attach a file. Actually, I don't know if it's possible or not, that's what I'm trying to figure out - how to attach a specific file (FileName.pdf from the Excel Spreadsheet).
Hi @victornabreu ,
If you can get the name of the file, then you can get the file content and send it as an attachment.
Image reference:
Best Regards,
It took some adjusting, since the FileName comes from a Row in excel - and Microsoft Flow tends to create a "apply for each" since it comes from an array. So there are two lists, one list of files and one list of excel rows.
But your suggestion worked, @v-bacao-msft .
I will leave a print of the final flow