Unanswered

Email each row of a SharePoint list to different email addresses

Like (0) Share

Report

Posted on 5 Mar 2021 02:29:34 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

I have the same question (0)

All responses (3)

Answers (0)

v-duann-msft on 12 Mar 2021 at 08:12:32

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

Was this reply helpful? Yes No
Trevasta 6 on 05 Mar 2021 at 14:06:17

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.

Was this reply helpful? Yes No
v-duann-msft on 05 Mar 2021 at 03:20:25

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

Was this reply helpful? Yes No