Unanswered

how to copy data from one table to another when selecting a lookup field in model driven app

(0) Share

Report

Posted on by jorenchristiaen

Hello everyone

I am trying to get the data of a related record that i select in a lookup. So when the lookup field is selected, that the entire form gets filled up with the data that comes from that related record in the lookup field. Can anyone help me to fix

Categories:

Microsoft Dataverse with Power Apps

image.png

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @jorenchristiaen,

Do you need to save the same data from the related record, or do you just need to view the related data? If you just need to view related data, you could create a Quick View form for the related table and add it to your form. The quick view form would show up whenever the Lookup has a selected record populated.

If you need to populate data from a related entity, you can define Attribute Mappings on the 1:N relationship. If on the related record form you have a subgrid to this entity and click + (Add New), when it opens the create new form it will pre-populate the values of the related record including the lookup. Note that this will not auto-populate if you are just creating a new record without coming from the related record.

The other way to populate the fields is with a JavaScript web resource, registered to the OnChange event of the Lookup field. You would retrieve the related record using the Lookup value selected. Then you can set the form values using the related record you retrieved.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
nandiishdave5 8 on at

Like (0)

Report

Thanks for the question and answer both. It helped me to solve my problem.

For second solution that you have given I have written simple js code and put it to field OnChange Event.

function OnChangeEvent(executionContext, lookupfield, namefield) {
var formContext = executionContext.getFormContext();
if (formContext.getAttribute(lookupfield).getValue() != null) {
formContext
.getAttribute(namefield)
.setValue(formContext.getAttribute(lookupfield).getValue()[0].name);
} else {
formContext.getAttribute(namefield).setValue("");
}
}

Please refer it if anyone needs help 🙂

Was this reply helpful? Yes No
nandiishdave5 8 on at

Like (0)

Report

Thanks for the question. It wanted to do same thing.

For second solution that you have given I have written simple js code and put it to field OnChange Event.

function OnChangeEvent(executionContext, lookupfield, namefield) {
  var formContext = executionContext.getFormContext();
  if (formContext.getAttribute(lookupfield).getValue() != null) {
  formContext
.getAttribute(namefield)
.setValue(formContext.getAttribute(lookupfield).getValue()[0].name);
} else {
  formContext.getAttribute(namefield).setValue("");
}
}
Hopefully it will help to someone who needs similar solution 🙂
Please refer it if anyone needs help

Was this reply helpful? Yes No
danny90 149 on at

Like (0)

Report

Hi @nandiishdave5

Any chance you could elaborate on how to use this Js? im really struggling to get it to work 🙂

Thanks!

Was this reply helpful? Yes No