Answered

Single Email filter array help

(1) Share

Report

Posted on by Zinerva2

I have a SharePoint List that has multiple columns that contain email addresses. I need to have a single email sent for all the emails listed for the 1 SharePoint Item. Below is the SharePoint Rows that include email addresses or a person card.

How would I build an array that doesn't nest multiple For Each in it so that I can add all the email addresses to the Send To section of my email flow?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Zinerva2

Is this email address you collecting from Microsoft Forms? I can't see in your screenshot you are doing Get Items. I can see create item. Could you please explain?

Thanks

Was this reply helpful? Yes No
Tomac 4,066 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here's an example to accomplish your goal. You'll want to use a String, not an Array, to store the email addresses. Step through the list items in a single Apply to Each action and append the current email address to your string with a semicolon after the dynamic field. Then outside of the loop, send your email.

Was this reply helpful? Yes No
Tomac 4,066 Moderator on at

Like (0)

Report
Copy link

Link copied!

Additionally, reference this solution to see how to get a bunch of values from within the returned JSON object into an array, then follow the steps above to extract the email addresses into a string for your Send An Email action: https://powerusers.microsoft.com/t5/Building-Flows/Convert-Object-to-an-Array-Within-an-Apply-to-Each/td-p/1438185

Was this reply helpful? Yes No
Zinerva2 98 on at

Like (0)

Report
Copy link

Link copied!

I'm getting the email addresses from Create Item. I'll have a total of 18 different email addresses, each one from a different column of the create item. I'm testing with just 2 selections right now but the Join function keeps failing.

Was this reply helpful? Yes No
Verified answer

Zinerva2 98 on at

Like (0)

Report
Copy link

Link copied!

I discovered the issue with my flow - it had to do with the formatting of the column in the SharePoint list. Once I changed the multiple lines of text column from enriched to plain text the join function worked as expected.

Was this reply helpful? Yes No