Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

I want to populate lookup value in child entity subgrid which has also this lookup field

Posted on by 60

I have a lookup field on parent entity which should be populated in all existing or newly created record in child  entity which present as a subgrid in parent entity  form. So,

basically populate all subgrid record with the lookup value (field) present on the main form

Can I get the sample javascript code to do it?

Thanks in Advance.

  • Verified answer
    Kosenurm Profile Picture
    Kosenurm 85 on at
    RE: I want to populate lookup value in child entity subgrid which has also this lookup field

    I'm not sure this is the best code, but it should work as I do similar in my model driven app. Xrm.Page is deprecated so I think this should be updated.

    function populateLookupChildRecords() {
    var parentRecordId = Xrm.Page.data.entity.getId();
    var lookupValue = Xrm.Page.getAttribute("new_lookupfield").getValue();

    // Get the child entity records
    var childRecords = Xrm.Page.getControl("childentity_subgridname").getGrid().getRows().get();

    for (var i = 0; i < childRecords.length; i++) {
    var childRecordId = childRecords[i].getData().getEntity().getId();

    // Set the lookup value on the child record
    var entity = {};
    entity.new_lookupfield = { Id: parentRecordId, LogicalName: "parententity_logicalname" };

    Xrm.WebApi.updateRecord("childentity_logicalname", childRecordId, entity)
    .then(function success(result) {
    console.log("Lookup value set on child record with ID: " + childRecordId);
    },
    function (error) {
    console.log(error.message);
    });
    }
    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans