Forum Discussion
Grouping two items
X10933333333 I don't think I completely understood your question. From what I understood, you can create a Person column and select 'Work Email' for display. When creating a new item, you can lookup the person by their name, once data is saved, email will be displayed in list view.
If you want a separate column with email information, you can use a simple power automate to lookup the user and fill in their email information as well.
- Bharath ArjaAug 01, 2022Iron ContributorIf you use a people picker field, you don't need to capture email separately. You can utilize the user identity from people picker to send email.
- X10933333333Aug 01, 2022Copper Contributor
yes but I don't use send e mail screen on power apps, I created a normal canva and picked e mail adresses from the sharepoint list. Bharath Arja
- ganeshsanapAug 02, 2022MVP
X10933333333 If you are using person or group column in SharePoint, you can easily get the email address from same column inside power apps.
Don't use two separate text fields for user name & email because they are chances users may enter wrong name or email. So it's always better to user person or groups column. It also shows the user suggestions while entering the data in the field.
Example: If you are showing the data in gallery inside power apps, you can show the email address from person or group column in label control by setting its "Text" property to:
ThisItem.PersonOrGroupColumnName.EmailReplace "PersonOrGroupColumnName" with name of your person or group column.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.