Flow Sending Multiple emails instead of one - Please Help :)

[Sheen]

Hi Folks, 

I am fairly new to flows and hoping to get some help on this.

I have two lists :

List 1 - Opportunities List (Sharepoint - hosts a list of roles that I want to be sent out via email if the role requires a discipline that is relevant to a line manager, this happens twice a week)

List 2 - List of Line Mangers & Disciplines (Excel - holds the data of every line manager and the discipline types that report to them)

I have managed to build my flow so that it is filtering out the relevant roles/line manager however it is sending out a separate email/line manager instead of putting them into one email.

The other issue I have is when I put in a HTML table it creates multiple lines for each role 😞

Any help would be greatly appreciated, I am starting to feel very incapable after attempting to fix this for a while now

See below a snapshot of the flow

[creativeopinion]

@Sheen The logic in your flow needs to be adjusted. You need to use a Filter Array action to compare the items from your SP list to your Excel table. The reason you are getting multiple emails is where your Send an Email action is nested. Its currently nested inside an Apply to Each action meaning each time the Apply to Each action loops through, it'll run that action. Take a look a this YT Tutorial I recently uploaded: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter 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

For your specific scenario, refer to the Referencing Data section of the tutorial.

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

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! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[v-yetonggu-msft]

Hi @Sheen ，

I did a test for your reference.

In my scenario:

length(body('Filter_array'))

{
"Name":@{items('Apply_to_each')?['ColumnName']},
"Description":@{items('Apply_to_each')?['ColumnName']}
}

Best Regards,

Sunshine Gu