Send e-mail (V2) with dynamic recipient

[_Livearus]

Hello everyone,

I keep facing the problem that one or more "for each" loops are added when I put dynamic content in the field "to" in the action "Send email (V2)". This is necessary to get the email addresses from the SharePoint column (people/groups column).

For example, I have 4 SharePoint elements. Each 2 entries have different recipients. When the flow is executed, both recipients receive an e-mail, but it does not stay that way. Each recipient receives a summary of the 4 SharePoint items according to the number of possible recipients. With two recipients, each recipient receives 2 e-mails with 4 items from all recipients.

How do I prevent this? So that only each recipient really receives an e-mail with their items?

[Sayan]

Hey @_Livearus 

Due to the 2 For_Each this issue occurs.

Can you please share the Screenshot or the SharePoint file that you are using?

Also share that in every foreach what expression you are using.

------------------------------------------------------------------------------------------------------------------------------

Thanks,

Sayan Patra | RPA Developer

[_Livearus]

Hello @Sayan 

I already thought that. But I can't prevent the editor from creating these two loops as soon as I insert the dynamic content into the "Send e-mail (V2)".

If I correct this manually, I get an error message that the loop is expected.

The dynamic value in the action "Send email (V2)" comes from a person/group column (SharePoint List)

[Sayan]

Hey @_Livearus 

Just need one Confirmation that You are fetching the Emails from a SharePoint List or anything else.

Thanks,

Sayan Patra

[_Livearus]

Hello @Sayan 

By "Confirmation" you mean just a single loop, right? But obviously I can't change that?

[Sayan]

Hey @_Livearus the images that you have provided.

IS this action fetching Data from a List?

[creativeopinion]

@_Livearus You might find these YT Tutorials linked below helpful. If you still run into issues while building your flow please upload a screenshot of your flow with the New Designer toggled off. Ensure you've clicked on each action to expand it and upload a screenshot of your flow in edit mode.

How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.

First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.

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 Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate

Do you want to know how to send an email to all users assigned to a SharePoint item? If so—this Power Automate tutorial is for YOU 🫵.

In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams. Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.

IN THIS VIDEO:

✅  How to trigger a flow from a selected file

✅  How the multi-person column data outputs

✅  How to use the Select action to get all assigned to users of a SharePoint item

✅  How to use the Join action to convert an array of email addresses into a string

✅  How to send a single email to all assigned to users of a SharePoint item

✅  How to send an email to each assigned to user of a SharePoint item

✅  How to send a Teams message to each user assigned to a SharePoint item

✅  How to return a list of unique users from the multi-person column in a SharePoint list

✅  How to use a Filter Array action to return all SharePoint list items assigned to each user

✅  How to group Power Automate actions together with the Scope action

✅  How to edit a previous flow

=

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