Unanswered

Pull SP people picker and concat emails

(0) Share

Report

Posted on by kingy61422

I have a SP list that has a multi-select people picker and I'm trying to pull the emails from the 'Tasked Org. POCs' column. After I get the emails I want to concat them using a semicolon and have the concat in a collection. This function will be used to send an email to all the emails in the list from the app using a built in email function.

Is there a way for me to extract the emails from the SP people picker and have those emails in a collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @kingy61422 , Which control you are using in app to choose multiple user from People Picker. Lets say in App you are using combo box then below code will help you concat:
Concat(ComboBoxName.SelectedItems,Email, " ;")
If this is not what you are looking then please elaborate more on requirement with screenshots.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ 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 giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
kingy61422 on at

Like (0)

Report

I'm trying to use the OnVisible function of a screen to get the emails so the user doesn't have to select to many people.

I've used this to get the list items, checked the collection and all was good.
ClearCollect(colOrderDistro,Filter(PA2_OrderTaskedOrgs,!IsBlank('Tasked Org. POCs')));

Tried this code since I wasn't getting any errors but checked the collection and was nothing but semicolons
ClearCollect(distro,Concat(ForAll(colOrderDistro,'Tasked Org. POCs'), ";"))

This is for the built in email function:
Set(_emailOrderDistro,Concat(ForAll(colOrderDistro,'Tasked Org. POCs'), ";"));
Office365Outlook.SendEmailV2(
_emailOrderDistro,
TextEmailSubject1_2.Text,
RichTextEditor1_1.HtmlText
)
From my SP list column:

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @kingy61422,There is no needto use a collection.

Could you please confirm that if this 'Tasked Org. POCs' column is a Person type allowing multi select?

If it is a Person type allowing multi select, please use the following formula as below:

Office365Outlook.SendEmailV2( Concat(Distinct(ForAll(Ungroup(PA2_OrderTaskedOrgs,"Tasked Org. POCs"),Email),Value),Value,";"), TextEmailSubject1_2.Text, RichTextEditor1_1.HtmlText )

Was this reply helpful? Yes No