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 |
---|---|
184 | |
124 | |
89 | |
45 | |
43 |
User | Count |
---|---|
262 | |
160 | |
128 | |
81 | |
73 |