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

(1) Share

Report

Posted on by AK-24060956-0

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/.

I have the same question (0)

All responses (3)

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AK-24060956-0 4 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates