Forum Discussion
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 in the name column I want to get e mail adress of xyz automatically in the e mail column.
Any ideas how can I do that?
9 Replies
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.
- Actually 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.
- If 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.
- So what happens if you have 2 people with the same name?
- By name I mean name and surname: I want to write Rob Elliott and want to get rob elliott's e-mail that I have defined before.
- My question is still, what if you have 2 Rob Elliotts? You have to have some way to deal with that.
