Unanswered

Send email with multiple attachments at certain time

(0) Share

Report

Posted on by Mirela_Raducanu

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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mirela_Raducanu 37 on at

Like (0)

Report

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

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report
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)

Was this reply helpful? Yes No
Mirela_Raducanu 37 on at

Like (0)

Report

@lbendlin Thanks for the clarification.
I tried to implement your suggestion and i have the following:
Unfortunately i received 2 emails without attachments. Any idea what i'm doing wrong?

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No