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

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.

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 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

Was this reply helpful? Yes No