Get Email Address form Person Picker

Like (0) Share

Report

Posted on 19 Mar 2023 12:59:09 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:

General Questions

All responses (3)

Answers (1)

Verified answer

Angry_Sys_Admin 181 on 19 Mar 2023 at 14:15:36

Like (1)

Report

Re: Get Email Address form Person Picker

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.
Angry_Sys_Admin 181 on 19 Mar 2023 at 13:42:33

Like (0)

Report

Re: Get Email Address form Person Picker

@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
Community Power Pla... on 19 Mar 2023 at 13:33:23

Like (0)

Report

Re: Get Email Address form Person Picker

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 😀