Forum Discussion
X10933333333
Aug 01, 2022Copper Contributor
Grouping two items
Hello everyone. I want to create a sharepoint list that gives specific items for specific items. My goal is to get e mail adresses of people when I write their names. For instance if I write xyz...
Bharath Arja
Aug 01, 2022Iron Contributor
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.
- X10933333333Aug 01, 2022Copper ContributorActually I want to do that for my power apps project. I want to show name selection list to the user. The aim is to sending an e mail based on the name and surname information provided by the user. Currently I offer name and e mail options together but this is not something user friendly.
- 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