Unanswered

Email each row of a SharePoint list to different email addresses

(0) Share

Report

Posted on by Trevasta

I have a list on SharePoint that includes email addresses on each row. I would like to run an automation that emails each row to the corresponding email address.

An issue I'm having is that although the information is correct, the table is being created with the total number of rows from the SharePoint list with the information being repeated to fill in the remaining rows.

My SharePoint list

My email output

My flow

All responses (3)

Answers (0)

v-duann-msft on at

Like (0)

Report

Re: Email each row of a SharePoint list to different email addresses

Hi @Trevasta

Thank you for update.

If the provided solution still not work for you. I recommend you go to below website to request a remote troubleshooting support.
https://flow.microsoft.com/en-us/support/

Thanks
Anna
Trevasta 6 on at

Like (0)

Report

Re: Email each row of a SharePoint list to different email addresses

Thank you for the response!

To clarify, is there a particular column I'm choosing for 'columnname'? I'm using the first column in my data set which is labeled "Site", but I'm still getting duplicate records. I renamed it to a few different column names to see if it made a difference but I still receive duplicates.
v-duann-msft on at

Like (0)

Report

Re: Email each row of a SharePoint list to different email addresses

Hi @Trevasta

Thank you for posting.

According to your description, you succeeded running flow but got duplicate records.

If that’s the case, please add ‘filter array’ action between ‘apply to each’ and ‘select’.

In filter array action, we should input @equals(items('Apply_to_each')?['columnname'], item()?['columnname'])” to only loop one record. Since there is no dynamic content under get items, thus, we can use advanced mode to edit.

You can also refer below link for reference.
Solved: Apply to each Person - Power Platform Community (microsoft.com)

Hope the content above may help you.

Thanks
Anna