web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Create string of multi...

Power Apps - Building Power Apps

Suggested answer

Create string of multiple emails from a person column in a collection

(0) Share

Report

Report

Posted on by lumberjacklurch

437

I am trying to set up an email screen in an app I'm working on, and I am having difficulty with setting up the "To:" text input.

I have a collection (ex colUserList) that has a person column in it.

My goal is to gleen the email address of everyone in the collection, and make a string of emails that will populate the text input box.

For example, the ending string would look like:

person1@email.com,person2@email.com,person3@email.com,etc

TBH, I'm having a hard time wrapping my head around on how to do this. Can I use a ForAll loop for this?

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

WarrenBelz 150,771 Most Valuable Professional on at

Like (0)

Report
Create string of multiple emails from a person column in a collection

Hi @lumberjacklurch,

If you want to put this output directly into the To: field of the mail
Concat( colUserList, PersonFieldName.Email, ";" )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

bspangler 5 on at

Like (0)

Report
Create string of multiple emails from a person column in a collection

It certainly looks like using a collection stops us from being able to use any of the properties from the Person column.

If you were using a SharePoint list as the data source directly, it would be something like this:

Concat(colUserList.personColumn, ThisRecord.Email, ",")

Was this reply helpful? Yes No
lumberjacklurch 437 on at

Like (0)

Report

Create string of multiple emails from a person column in a collection

Maybe something like this:

ForAll(ShowColumns(colUserList,User),

If(!IsBlank(User.Email), Collect(col_UserEmails,User.Email)

)

)

Was this reply helpful? Yes No