How do I attach Multiple PDF files from OneDrive and send a single email containing all the PDF files?

[srivatsa224]

Hi, 

I have built a Power Automate Flow by to send emails from Excel with attachments by going through this video on YouTube (Link). 

While I did not have an issue with the flow, I need to add multiple PDFs in the same email. Can you help me with the steps to add multiple PDFs in the same email? 
(I am attaching a screenshot for reference.)
I need to send one email each to two people here and there are 3 PDFs in the OneDrive folder, how can I send a single email by attaching all three PDFs in the same mail?
It would be great if you could assist me here.

Thanks in Advance!

[srivatsa224]

@DamoBird365 

Hi, can you help with this if possible please.

[DamoBird365]

Hi @srivatsa224 

You need to build an array of attachments. You do this with an apply to each containing a get file content using path and a compose, or if you’d prefer append to array.

The input to the apply to each is based on the files you want to attach. Either direct from get files or based on a filter.

check out the following point in one of my video that demos what you are trying to achieve https://m.youtube.com/watch?v=4b6idSbszuU&t=595s

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks 

[srivatsa224]

Hi @DamoBird365 ,
Thanks for the quick response and the link to tutorial.
But, I am using OneDrive instead of SharePoint and the options are quite different from what you have explained in the video.

As of now, I can send one email to people with one attachment matching their name. But, I want to send multiple PDFs in a single mail if it matches the name of the person. 

Could you please help me with this. 
I am also attaching the screenshots of the current working file of the Flow, let me know what needs to be changed. 

Thanks

[GabrielAgil]

Can someone please provide some answers to this? I need to do the exact same, but I can not identify Attachment 2 

[TommyGeorge]

You need to create an array

Please ensure that there are no quotes around the ContentBytes field in the format: `"ContentBytes": @{body('Get_file_content')}. Including quotes can cause PDF documents to appear blank.

For adding the array to the 'Send an email' action, place it directly in the attachments section, specifically in the attachment field. This method will include all attachments in one email. If you don’t see the array variable in the dynamic content list, simply click on the button indicated by the red arrow to add it manually.

The "Send an email" action should not be inside off the applytoeach