Microsoft Dynamics 365 | Integration, Dataverse...

How to get a record column value based on the selected lookup value?

(0) Share

Report

Posted on by bp3378

190

So I have a form that has the item lookup field. When i select the value for the field, I want the value of another column from that same selected lookup record.

For example one of the records of the items table:

primary name = glue, chemical = no

So in a form, when i select glue, I want another field in the form to show 'no'.

Is it better to use javascript or power automate? How to do it for each?

All responses (2)

Answers (0)

bp3378 190 on at

Like (0)

Report

RE: How to get a record column value based on the selected lookup value?

Guido Preite

How do I connect it to the lookup? The chemical field in this form is a text field, but the column attached to the lookup field is a choice.
Suggested answer

Guido Preite 54,075 Moderator on at

Like (1)

Report

RE: How to get a record column value based on the selected lookup value?

do you need to copy or just to show the value? because if you need to show you can use a quick view form connected to the lookup, if you need to copy, you can do with javascript (attach to the onchange event and use a Xrm.WebApi call to retrieve the field and copy to the desired field)