Seeking Advice: Consolidating Multiple Attachments into Single Email for Specific Location

Question

Hello everyone,

I've developed a workflow that reads a list of invoices, sorts them, and distributes them according to Fleet locations. The workflow functions perfectly until the final step, where it's supposed to email a single fleet contact with an email containing all the invoices for their location. However, instead of consolidating the attachments, it's sending one email per attachment. The number of attachments varies, and they're pulled into the workflow from a directory.

I'd greatly appreciate any advice on how to consolidate all attachments for a specific location into a single email. Thank you!

Workflow for Community Post- Redacted.png

Email Image for Community Workflow.png

Hammad_Rashid · Answer

I understand that you’re looking to consolidate multiple attachments into a single email for a specific location. I found a few resources that might help you with this.

One option is to use the Merge to Email as PDF Attachment feature on the Merge Tools tab of the ribbon when you have the document that you used to create the individual documents as the active document 1. Alternatively, you can try storing all the attachments in a single folder and then compressing the folder into a zip file. You can then attach the zip file to the email and send it to the recipient 2.

Another option is to use the Send email v2 action in Power Automate. This action allows you to send a single email with multiple attachments 3. You can also try using the Send email notification v3 action, which allows you to send an email notification with a single attachment. However, this action only allows one attachment per email 3.

I hope this helps!

Joe_McCoy · Answer

@Afgamble I have a workflow that does something similar, it reads a folder and creates hyperlinks to those files.  I use the table tool like you but following all of the joins and just prior to the email tool, I reuse the table tool so that the links are again in one table. The links are then sent to an AD email list. I know your email list is dynamic, but I hope this helps.

Joe