Get selected person's email address from AAD User table

(0) Share

Report

Posted on by Kosenurm

802

Hi,

I have a model-driven app whereby, there is a column field which is a look-up to the AAD User table, as below...

pp test.png

When the person in the search results is selected, this populates their name in the PeoplePickerTest field.

What I want is, when someone is selected in the lookup field of PeoplePickerTest, for the selected person's email address to automatically populate the form field below of PeoplePickerEmail with the selected person's email address.

I think I would need some kind of javascript to do this possibly? Or is there a simple way that I am missing?

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @Kosenurm,

You could use a calculated field or possibly the newer formula column to show the email based on the AAD User lookup. Note that calculated fields / formula columns are not stored values, but computed when retrieving the table record, so you won't see the value update in the user interface until you save the record (which will trigger a retrieve of the record and refresh the form).

If you need the email to display as soon as you select the record from the lookup, then a JavaScript web resource would be your other option. This thread shows an example of how to retrieve related data from a lookup column using JavaScript. You would register this function for the OnChange event of your lookup column on the form.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (0)

Report

Thanks for the info. I think the JavaScript web resource would be a good option.

In my model driven app form, I first need to select a JS library in order to then register a function. Which library would I pick for this?

Thanks

K

Was this reply helpful? Yes No