Dynamics Community Forum Thread Details

Concat 2 lookup field values

var List = formContext.getAttribute("c30_list").getValue(); var dListParsed = Array.isArray(List) ? List : []; var To = formContext.getAttribute("to").getValue(); var oContacts = Array.isArray(To) ? To : []; //code to retrieve and populate dContacts Array // do the merge like the other one var mergedContacts = [...oContacts]; dContacts.forEach(function (contact) { if (!mergedContacts.find(c => c.id === contact.id)) { mergedContacts.push(contact); } }); // Set the final merged TO value formContext.getAttribute("to").setValue(mergedContacts);

Good morning, afternoon, or evening depending on your location!

Some suggestions, if you haven't tried already -

Fixes & Improvements:

Ensure List is properly parsed
- You are using JSON.parse(List), but List might not always be a valid JSON string. Consider checking its type before parsing.
Fix variable name typo
- You are using dParsed[i].id, but dParsed is not defined. It should be dListParsed[i].id.
Ensure To field is correctly updated
- Instead of overwriting the To field, append new values while preserving existing ones.

Updated Code:
async function setDistributionList(executionContext) {
    var formContext = executionContext.getFormContext();
    var List = formContext.getAttribute("c30_list").getValue();
    var To = formContext.getAttribute("c30_to").getValue();

    const oContacts = [];
    const dContacts = [];
// Process existing "To" field values
    if (To !== null) {
        const ToArray = To.split(',');
        for (var i = 0; i < ToArray.length; i++) {
            var contactId = ToArray[i].trim();
            var fetchXML = `<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
                <entity name='contact'>
                    <attribute name='name' />
                    <attribute name='contactid' />
                    <filter type='and'>
                        <condition attribute='contactid' operator='eq' value='${contactId}' />
                    </filter>
                </entity>
            </fetch>`;

            await Xrm.WebApi.retrieveMultipleRecords("contact", "?fetchXml=" + fetchXML).then(
                function success(result) {
                    result.entities.forEach(entity => {
                        oContacts.push({ id: entity.contactid, name: entity.name, entityType: "contact" });
                    });
                }
            );
        }
    }
// Process List field values
    if (List !== null) {
        try {
            const dListParsed = JSON.parse(List);
            for (var i = 0; i < dListParsed.length; i++) {
                var dListName = dListParsed[i].id;
                var fetchXML = `<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
                    <entity name='contact'>
                        <attribute name='name' />
                        <attribute name='contactid' />
                        <filter type='and'>
                            <condition attribute='c30_to' operator='eq' value='1' />
                        </filter>
                        <link-entity name='c30_c30_dlist_contact' from='contactid' to='contactid' intersect='true'>
                            <link-entity name='c30_dlist' from='c30_dlistid' to='c30_dlistid' alias='ag'>
                                <filter type='and'>
                                    <condition attribute='c360_dlistid' operator='eq' value='${dListName}' />
                                </filter>
                            </link-entity>
                        </link-entity>
                    </entity>
                </fetch>`;
await Xrm.WebApi.retrieveMultipleRecords("contact", "?fetchXml=" + fetchXML).then(
                    function success(result) {
                        result.entities.forEach(entity => {
                            dContacts.push({ id: entity.contactid, name: entity.name, entityType: "contact" });
                        });
                    }
                );
            }
        } catch (error) {
            console.error("Error parsing List field:", error);
        }
    }
// Concatenate values without overwriting
    formContext.getAttribute("c30_to").setValue([...oContacts, ...dContacts]);
}
Key Fixes: