How to get a field value based on a lookup value?

(0) Share

Report

Posted on by bp3378

190

Hi, I have a user's name lookup value in the main form that looks up to a custom user table. So I know how to get the lookup value using javascript, but how can I get another field (user's email) using the user's name for that same record using javascript?

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

You will have to combine the following articles:

1. www.adyatantech.com/.../how-to-get-and-set-lookup-field-values-using-javascript - getting of the id from the lookup field placed on the form.

2. learn.microsoft.com/.../retrieverecord - querying the record information based on the record logical name and id.

3. The easiest way to pre-cook your query is to use Dataverse Rest Builder - github.com/.../DRB

Was this reply helpful? Yes No
Suggested answer

bp3378 190 on at

Like (0)

Report

Hi andrew butenko thanks for the reply. I have been using XMLHttpRequest(), which should I be using instead?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

I recommend using Xrm.WebApi, the second link I provided. If you want to generate the "stub" code that you will use after - use DRB, third link.

Was this reply helpful? Yes No