Multiple message

[Teresa_DL]

Dear all, 

I built the list below in sharepoint and I need an email to be sent every time the process is started. As you can see for each item there are several people who need to receive the email with the link.

The problem is that the system sends an email to all the recipients for each person in the list (eg. for Mali recipient received 3 emails, for Monzabique Gombe we all received 4 emails).

This is the flow I built:

Is there a function to make it so that one email is received by everyone?

[fchopo]

Hi @Teresa_DL 

I would recommend you to read the following post: Group a List for Summary Using Power Automate (flyingpolymath.com)

The idea would be the following:

1) Get all the items of the SharePoint list with Progress eq = Completed

2) Get distinct users of the previous list using a select and compose actions

3) With the array we got in step 2, for each member:

3.1) Filter array, create an html table and send the email.

Hope that helps you!

Ferran