Unanswered

How to Send Emails to Multiple Recipients, Each with a Unique Attachment

(0) Share

Report

Posted on by JR-19081559-0

I am pretty close but I just can't seem to find a missing piece in this flow. The goal is to use an Excel file that has two columns, one for the recipient email address, and the other for the name of the file the flow needs to grab and attach to the email. The filenames are all unique.

The flow below sends the emails to the recipients as desired, but it's not grabbing the attachment.

**Limit Entries to Folder is pointing to the folder that contains the PDF attachments. The Excel file I am filtering from is from one directory level above that.

*I wasn't sure about ID as the file identifier here. That was one dynamic option it gave me that seemed possibly logical.

*I wasn't sure about Title here but it's all that was listed in the dynamic options that seemed logical.

Any suggestions are highly appreciated! If we can get this to work, we'll use it all the time.

Categories:

Business Process Flows

All responses (4)

Answers (0)

Suggested answer

MarcLudwig 10 on at

Like (0)

Report

How to Send Emails to Multiple Recipients, Each with a Unique Attachment

Basically, your flow looks good, and it was working for me with a few adjustments.

I also agree with creativeopinion that getting all files at once and use filter array then, could be the more efficient solution here, but it depends a bit on the total amount of files in that folder in comparison to the length of the excel file.
This is how it looks like then

***Maybe you need to adjust the filter, if VIN is not really equal to the filename.

Furthermore, I used the '{Identifier}' to get the content of the files

And the last adjustment was to use the '{FileNameWithExtension}' field as Name of the mail attachment
creativeopinion 10,439 Super User 2025 Season 1 on at

Like (0)

Report

How to Send Emails to Multiple Recipients, Each with a Unique Attachment

The equivalent action in SharePoint to the List Files From Folder (OneDrive) action is Get files (properties only). You can specify the folder you'd like to limit entries from.

It's important to note that the Get Files (properties only) action will return files and folders. To limit the results to files only—you'll need to define a filter query. Refer to this YT Short.

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
JR-19081559-0 40 on at

Like (0)

Report

How to Send Emails to Multiple Recipients, Each with a Unique Attachment

I ended up using a YouTube video to at least get something working. I have not been able to get this to work with Sharepoint yet, but did get it working with OD for Business.

There is a step in the OD for Business process - List Files from Folder - that I have not found a working action for when using Sharepoint as the storage location instead.
creativeopinion 10,439 Super User 2025 Season 1 on at

Like (0)

Report

How to Send Emails to Multiple Recipients, Each with a Unique Attachment

It's always best practice to have the Get Files (properties only) action in the root of the flow. Instead of running this action each time your flow loops through a row in your Excel table—run it once and use a Filter Array action inside the loop to filter the item that matches what you are looking for. In your case you'd use the Filter Array action to filter out the file that matches.

For more information on how to use the Filter Array action, check out this YT Tutorial:

Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

---

You might also be interested in this YT Tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

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