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?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (1)

Report

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)

Was this reply helpful? Yes No
bp3378 190 on at

Like (0)

Report

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.

Was this reply helpful? Yes No