web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Appending Multiple Att...
Power Automate
Unanswered

Appending Multiple Attachments to Email

(0) ShareShare
ReportReport
Posted on by 13

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!

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

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

    creativeopinion_1-1713991368624.png

    Insert your attachment array variable here.

    creativeopinion_2-1713991381543.png

     

    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 Profile Picture
    13 on at

    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 Profile Picture
    10,502 Super User 2025 Season 2 on at

    @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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard