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
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.
If we 3 fields People Picker1 ,2,3 how can we concat all 3 in same formula ?
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) & ";")
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!
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.