Breaking News: Grepper is joining You.com. Read the official announcement!

how to get lookup field data form parent table to child table

WAJID answered on July 13, 2023 Popularity 1/10 Helpfulness 8/10

answer how to get lookup field data form parent table to child table

how to get lookup field data form parent table to child table

Comment

function getAccountDetails(executionContext) {
  let formContext = executionContext.getFormContext();
  let nameValue = formContext.getAttribute("firstname");
  let email = formContext.getAttribute("emailaddress1");
  let accNum = formContext.getAttribute("mobilephone");

  
  let lookupValue = formContext.getAttribute("parentcustomerid").getValue();
  
  if (lookupValue !==null) {
    // Getting Guid of record of parent table
    let accountId = formContext.getAttribute("parentcustomerid").getValue()[0].id.replace("{", "")
    .replace("}", "").toLowerCase();

    // Use Dataverse Rest Builder
    Xrm.WebApi.retrieveRecord(
      "account",
      accountId,
      // these are the fields of parent table from where we are getting values
      "?$select=name,accountnumber,emailaddress1 " 
    ).then(function success(result) {
      var accountid = result["accountid"]; // Guid
      var name = result["name"]; // Text
      var accountnumber = result["accountnumber"]; // Text
      var emailaddress1 = result["emailaddress1"];

      nameValue.setValue(name);
      email.setValue(emailaddress1);
      accNum.setValue(accountnumber);
    });
  } else {
    nameValue.setValue();
    email.setValue();
    accNum.setValue();
  }
}

Popularity 1/10 Helpfulness 8/10 Language javascript

Source: Grepper

Tags: get javascript lookup-field parent

Link to this answer
Share Copy Link

Contributed on Jul 13 2023

WAJID

0 Answers Avg Quality 2/10

how to get lookup field data form parent table to child table

Contents

More Related Answers

how to get lookup field data form parent table to child table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.