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?

All responses (3)

Answers (2)

Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (2)

Report

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

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.
Suggested answer

bp3378 190 on at

Like (0)

Report

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

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

a33ik 84,325 Most Valuable Professional on at

Like (2)

Report

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

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