Get Email Address form Person Picker

(0) Share

Report

Posted on by Angry_Sys_Admin

181

Hi all.

I have an new form linked to an SP list with 2 columns, a person picker and a text column.

In the form, when the person is selected, I need their email address from their profile to be automatically populated in the datacard linked to the text column.

So if I pick Jo Bloggs from the person picker I need their email address j.bloggs@company.com to appear in the text datacard which will then be saved to the text column in sharepoint.

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Angry_Sys_Admin ,

Assuming that you have combobox where you are populating users data. In order to get email address of selected person, you simply need to write ComboBox1.Selected.Mail
Here ComboBox1 is the name of my dropdown field

Let me know if this works for you and if it is then mark this as a solution.
Thanks 😀

Was this reply helpful? Yes No
Angry_Sys_Admin 181 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Thank you for your reply.

My person picker box is an ordinary datacard box in the form, not a combo box, this is what it looks like when I select the member or staffs name:

So I need Franks email address to appear in the email address text box to the right.

I tried earlier DataCardValue40. but the only options I got were .selecteditems, not .selected

Was this reply helpful? Yes No
Verified answer

Angry_Sys_Admin 181 on at

Like
a
(1)

Report
Copy link

Link copied!

Figured it out.

In the Update properties of your Email Address field, enter the DataCardValue of your person picker followed by selected.email

This doesn't make the email address appear in the text box, but is does write the email address to the text column in the SP list which for me is acceptable.

Was this reply helpful? Yes No