Email with multiple attachments without using Outlook connector

[Anonymous]

Hello, Power Automate Community!

I'm in the final steps of building a Flow and just realized I may have a problem.

The flow itself is working fine, but the last step involves sending an email with multiple attachments (an Excel sheet and one or more images) that are stored in an array variable. Right now I'm using an Outlook connector, but it involves using an account for every Flow execution (the one you sign in as when building the flow) and I don't want my coworkers to get automated messages from my account. Nor do I have access to a service account. 

In this post I saw someone suggest the Mail connector. I started testing it and fine, no more mails from me to everyone... but it seems like it doesn't support multiple attachments 😞

Is there any way to solve this? Seems like I need some features from the Outlook connector and some from the Mail connector, but none alone satisfies the requirements.

Thanks in advance!

[Jay-Encodian]

Hey @Anonymous 

That's pretty tricky... I checked and surmised the same that the 'Mail' connectors action only accepts a single attachment and to send as another mailbox using the O365 Outlook connector you need either permissions to another mailbox or a dedicated service account... I also checked the SendGrid connector and this only accepts a single attachment as well.

You could add all the attachments to a Zip file and send the 'zip' using the Encodian connector? This isn't the exact scenario but shows you how to create the Zip file from an array: New Power Automate Action: Add to Archive (ZIP) 

Note: The Encodian connector provide a free plan for 50 actions per month, paid plans required for larger throughput... it might be more cost effective to setup a service / account... one to check.

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

[v-bacao-msft]

Hi @Anonymous ,

Unfortunately, neither of these actions seems to meet your needs.

Send an email from a shared mailbox (V2) action was an alternative method, but it seems you have no way to use it.

If you want to add multiple attachments to the Send an email notification (V3) action, please consider submitting your suggestions in the ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/FlowIdeas

Also, could you tell us where these files are stored? If it is OneDrive or SharePoint Library, maybe you can send file link or sharing link directly.

Best Regards,

[Anonymous]

Thank you for your reply, @v-bacao-msft.

The image(s) are stored in CDS, and the Excel is in OneDrive.

I guess I could share the Excel link in the mail body and send the image as attachment, but that doesn't cover all the cases since most of the time there would be more than one image to attach.

I'll submit my suggestions to the ideas forum.

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

If the files are stored in a CDS, it becomes difficult to add multiple images as attachments.

I hope that a similar feature can be supported at an early date, and I will also recommend more other users with the same need to vote for this idea.

Best Regards,