Appending Multiple Attachments to Email

[powercrusher]

Hello,

I am looking for some help with my Flow. The intention of this Flow is to run a weekly extract of data from two separate tables, containing data from the past seven days, before sending two CSV files to the user. However, I am encountering issues with the final step (Send an email notification (V3)). 

What I've done is as follows:

Thumbnail 1:

1. Set recurrence for Mondays at 12AM.
2. Initialize EmailAddress (users to receive this email)
3. Initialize StartDateTime and EndDateTime (to determine the 7-day period)

Thumbnail 2:

     4. List rows from both Dataverse tables

     5. Select rows

     6. Create CSV

(All steps above this point worked ok in a prior app that only required one attachment)

     7. Create Attachment Array EmailAttachments

• Name: "Filename1.csv" and "Filename2.csv"
• ContentBytes: "Output1" and "Output2" (both from the Create CSV step right before)

Thumbnail 3:

     8. Compose Attachment Array using EmailAttachment as input

     9. Send Email Notification

• Attachment: set to use Content from Output composed
• Attachment File Name: set to use Name from Output composed

This is resulting in errors when running the flow, which I suspect to be from Steps 7, 8, and 9, but I'm not quite sure what to do. Please help!

[creativeopinion]

@powercrusher You need to use the Send an Email (V2) action. Click on the icon to switch the attachment input mode.

Insert your attachment array variable here.

You might also be interested in these tutorials: 

How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

----

How to Send SharePoint List Attachments 📎 via Email with Power Automate

In this Microsoft Power Automate tutorial, I’ll cover how to create a Power Automate flow to send SharePoint list attachments in an email.

This flow will check the SharePoint list to see if an item is marked as Ready to Send and has attachments. I will also cover how to combine multiple attachments to send in a single email.

IN THIS VIDEO:

✅ How to attach a single SharePoint list attachment to an email

✅ How to use the Filter Query to Filter SharePoint List Items by a Single Choice Column

✅ How to use the Filter Array action to Filter SharePoint List Items that have an Attachment

✅ How to use turn on Pagination and Set a Threshold in the Get Items action

✅ How to us the Top Count field in the Get Items action

✅ How to use the Get Attachments Action

✅ How to avoid the Apply to Each Action

✅ How to use the Get File Content Action

✅ How to Edit an Expression

✅ How to use the Compose Action

✅ How to Get Multiple SharePoint Attachments

✅ How to use the Append to Array Variable Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[powercrusher]

Hello! Maybe I'm a little new to this, but I'm using the native (?) Microsoft Mail connector and not the Office 365 Mail that you're showing. I think that's why I don't have that option. Are there any alternatives that you know of? Thank you! 

[creativeopinion]

@powercrusher If you need to use the Send an email notification (V3) – Mail action instead of the Send an Email (V2) – Outlook it looks like you are limited to attaching a single attachment. You'll need to combine your csv data into one file.