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?
Solved! Go to Solution.
Concat(AdminNames.SelectedItems.Email, Text(Email) & ";")
Concat(AdminNames.SelectedItems.Email, Text(Email) & ";")
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!
User | Count |
---|---|
196 | |
125 | |
88 | |
49 | |
42 |
User | Count |
---|---|
285 | |
162 | |
138 | |
76 | |
73 |