Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send email with multiple attachments at certain time

(0) ShareShare
ReportReport
Posted on by 37

Hi, i want to create a flow which sends one email with several attachments but excludes other files saved in the same folder.

The flow needs to check daily if files that meet certain criteria were added to a folder and if so to send these via email at a certain time. 

The criteria that needs to be met by the files in order to be sent out as attachments is: file name should contain word "X" or word "Y". 

Thanks for the help!

  • lbendlin Profile Picture
    8,041 Super User 2025 Season 1 on at
    Re: Send email with multiple attachments at certain time

    How many files are in that folder? What is their combined size? There is a 100 MB message size limit in Power Automate but your email system likely has a lower limit for overall attachment size.

     

    Look at the run history for the flow and check the contents of the array variable.

  • Mirela_Raducanu Profile Picture
    37 on at
    Re: Send email with multiple attachments at certain time

    @lbendlin Thanks for the clarification. 

    I tried to implement your suggestion and i have the following:

    Mirela_Raducanu_0-1690468655946.png

    Mirela_Raducanu_1-1690468717858.png

    Unfortunately i received 2 emails without attachments. Any idea what i'm doing wrong?

  • lbendlin Profile Picture
    8,041 Super User 2025 Season 1 on at
    Re: Send email with multiple attachments at certain time
    The flow needs to check daily 

    Your flow doesn't do that. Instead it fires "each time a file is created or modified". That also means that your email will always only contain a single attachment (namely the file that triggered the flow).

     

    Either change your trigger to a schedule  (but then you would need to modify the flow to collect all files that have been modified since the last time the flow ran)  or reformulate your business requirement.  Sending files that changed on a sharepoint as email attachments seems inefficient, and may not work if the files are large (beyound 25 MB, for example)

  • Mirela_Raducanu Profile Picture
    37 on at
    Re: Send email with multiple attachments at certain time

    Hi @lbendlin , 

    Please see below the steps, the flow works to some extent. It sends out the attachments in separate emails instead of sending one email with 2 attachments. Does this happen because the 2 files are not saved simultaneously on SharePoint? If yes, maybe a possible solution is to set a flow which checks at the end of the day what new files have been added to SharePoint and then send the email?

    Thank you for the help!

    Mirela 

     

    Mirela_Raducanu_0-1690447983324.pngMirela_Raducanu_1-1690448043151.pngMirela_Raducanu_2-1690448080847.png

     

  • lbendlin Profile Picture
    8,041 Super User 2025 Season 1 on at
    Re: Send email with multiple attachments at certain time

    ok. what have you tried and where are you stuck?

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1