cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver III
Resolver III

Getting emails from people picker combo box

I have a SharePoint Person or Group field which allows multiple selections. On the PowerApps side I want to get all of the emails to store like this: selectedUserA@contoso.com;selectedUserB@contoso.com

For now I have a label which I'm using to test building this new value. The Text prop is

Concat(AdminNames.SelectedItems.Email, ";")

where AdminNames is the data card value for the combo box

It's displaying two semicolons so I know that it can tell there are two selected users but it's not displaying any emails. Is there a way to rework the formula to show these?

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver III
Resolver III

Concat(AdminNames.SelectedItems.Email, Text(Email) & ";")

View solution in original post

4 REPLIES 4
Resolver III
Resolver III

Concat(AdminNames.SelectedItems.Email, Text(Email) & ";")

View solution in original post

Anonymous
Not applicable

Hi @cooper33 do you still need help with this?

 

@Anonymous 

If we 3 fields People Picker1 ,2,3 how can we concat all 3 in same formula ? 

 

Update:

I managed to concat multiple people picker fields in a lable. It will list all the email address of the users and separate by ; which helped me in sending emails directly from power apps 

 

Concat(DataCardValue3.SelectedItems.Email, Text(Email) & ";") & Concat(DataCardValue4.SelectedItems.Email, Text(Email) & ";") & Concat(DataCardValue5.SelectedItems.Email, Text(Email) & ";")
 Office365.SendEmail(Label1.Text,"","") 

 

I was beating my head against my desk  to get this to work and you gave me the right answer with Text(Email)!  Technically I wanted the DisplayName, so I ended up with the following:

 

Concat(DataCardValue10.SelectedItems.DisplayName, Text(DisplayName &"; "))

 

 

Thanks for posting this solution!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (38,253)