Unanswered

Send an email to all individuals in a SharePoint List

(0) Share

Report

Posted on by dvrdn72

I have a SP list that has entries from multiple PMs. Some of the PMs have multiple entries. I need to send a single email to all the PMs listed in the column called PM. I am having issues getting the email addresses pulled and then added to the TO line of the email. Below is a snip from the SP list.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@dvrdn72 Use get items first then use select action. In select action click switch map to text mode option and add PM emails. Now use one compose and use union() for select. This will give you unique emails for PM column. Then use apply to each. Inside apply to each use get items again with filter query with loop current item. This will give you all items related each PM email. Then you can create html table and send email.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
salzabet 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @Hardesh15 , you think you can elaborate a bit on the steps inside the apply to each loop? Not too sure how the grouping works and inputted into the HTML table.

thanks

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@salzabet After union() you will have all unique values in an array. Loop will take one array element at a time and get respective details from get items 2(using filter query) which will be used in HTML table. This way for each user you can send email with all line item.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Kyo_Kilava 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Hardesh15 one quick question ... suppose I need to send in one single email to all the "unique recipients" , meaning that I dont have to iterate the list one row and after another ... but to send 1 email to all the email addresses that I have after I have filtered the repeated email addresses that are in the HTML table .. how can I do that ??

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Kyo_Kilava Sorry for the late reply. was busy in project work. You can store all emails in a variable. Initialize a variable of type string and then use append to string action in which add email with ';' so that send email action recognize each email.

Then out of the loop use send email action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No