cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cooper33
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
cooper33
Resolver III
Resolver III

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

View solution in original post

4 REPLIES 4
cooper33
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

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

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (62,806)