News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Trying to find out how...

Microsoft Dynamics CRM forum

Unanswered

Trying to find out how to insert a child lookup into a parent lookup field value using xrm.webapi

(1) Share

Report

Report

Posted on by AK-24060956-0

4

I am not sure using javascript we can create an object that will add its child lookup value into it.

Any help would be appreciated on this topic.

Thanks

here I am trying to add signatureLookup value to the field of queue object i.e. /emailsignature/.

Categories:

All responses Img

All responses (3)

Answers Img

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report

Trying to find out how to insert a child lookup into a parent lookup field value using xrm.webapi

Hi,

Auto populating the queue to the From field can be achieved with the following code.

function onload(executionContext) {
var fetchXML = `?fetchXml=
<fetch mapping='logical'>
<entity name='queue'>
<filter type='and'>
<condition attribute='name' operator='eq' value='<Queue name>'/>
</filter>
</entity>
</fetch>`;
Xrm.WebApi.retrieveMultipleRecords("queue", fetchXML).then(
function success(result) {
var lookup = new Array();
var lookupvalue = new Object();
lookupvalue.id = result.entities[0].queueid;
lookupvalue.name = result.entities[0].name;
lookupvalue.entityType = "queue";
lookup[0] = lookupvalue;
executionContext.getFormContext().getAttribute("from").setValue(lookup);
},
function (error) {
console.log(error.message);
}
);
}

Best Regards,
Dengliang Li
AK-24060956-0 4 on at

Like (0)

Report

Trying to find out how to insert a child lookup into a parent lookup field value using xrm.webapi

Thanks Dengliang, but according to this post, we are copying the value from a system user lookup field to another system user lookup field.

However, what I am trying to achieve here is Queue is a parent entity here and there is a emailsignature lookup field under Queue record that I am fetching using xrm.webapi via fetchxml.

after this fetch, I want to populate this Queue record to a From field which is a lookup for Queue records.

I am attaching the Queue record to From field using following snippet -

However this Lookup[0] Object from lookup array is a brand new record of Queue entity that is not holding any reference to emailsignature record inside it.

can we somehow reference the emailsignature record inside lookup[0] record object ?
Dengliang Li Microsoft Employee on at

Like (0)

Report

Trying to find out how to insert a child lookup into a parent lookup field value using xrm.webapi

Hi,

Please refer to the following link.

How to Set a Lookup Field to Another Lookup Field on a Dynamics 365 Power Apps Form using JavaScript - Carl de Souza

Best Regards,
Dengliang Li

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,493 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans