cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa_DL
New Member

Multiple message

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.

Teresa_DL_0-1674638736059.png

 

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:

Teresa_DL_1-1674638876105.png

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

1 REPLY 1
fchopo
Super User
Super User

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

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,972)