Seeking Advice on Displaying Values from a Lookup Field in a Model-Driven App Form

[TaraAssadipour]

Hello, Power Platform Community!

I'm working on a Model-Driven App and facing a bit of a challenge. I have a form/table setup where there's a lookup field named "tara_condition" linked to the table "cr858_engconditionlibrary2". This table contains a field "cr858_originalcondition" whose value I want to display in another text field "tara_conditiontext" on the same form every time the lookup value changes. The goal is for the user to view and potentially update this value in the "tara_conditiontext" field without modifying the original value stored in the "cr858_engconditionlibrary2" table.

Currently, I'm trying to achieve this using JavaScript, but I've hit a snag. My JavaScript code that utilizes XMLHttpRequest (XHR) isn't working as expected; it's resulting in a readyState of 1 and a status of 0.

I'm reaching out to see if there might be another approach to handle this scenario that doesn't involve writing JavaScript, or if JavaScript is necessary, perhaps a method that bypasses these XHR issues. Any suggestions or guidance would be greatly appreciated!

Thank you in advance for your help!

function populateTextbox() {

    var conditionLookup = Xrm.Page.getAttribute("tara_condition"); 

    var conditionTextbox = Xrm.Page.getAttribute("tara_conditiontext"); 

    if (conditionLookup && conditionTextbox) {

        var conditionLookupValue = conditionLookup.getValue();

        if (conditionLookupValue && conditionLookupValue[0]) {

            var conditionId = conditionLookupValue[0].id;

            var conditionName = conditionLookupValue[0].name;

      var encodedConditionId = encodeURIComponent(conditionId);

            // Perform a Web API request to retrieve the value of the Original Condition field

            var req = new XMLHttpRequest();

            req.open("GET", Xrm.Utility.getGlobalContext().getClientUrl() + "/api/data/v9.1/cr858_engconditionlibrary2s(" + encodedConditionId + ")?$select=cr858_originalcondition", true);

            req.setRequestHeader("OData-MaxVersion", "4.0");

            req.setRequestHeader("OData-Version", "4.0");

            req.setRequestHeader("Accept", "application/json");

            req.setRequestHeader("Content-Type", "application/json; charset=utf-8");

            req.onreadystatechange = function () {

                if (this.readyState === 4) {

                    req.onreadystatechange = null;

                    if (this.status === 200) {

                        var result = JSON.parse(this.response);

                        var originalCondition = result["cr858_OriginalCondition"];

                        conditionTextbox.setValue(originalCondition);

                    } else {

                        // Handle error

                    }

                }

            };

            req.send();

        } else {

            conditionTextbox.setValue(null);

        }

    }

}

// Register the onChange event handler for the lookup field

Xrm.Page.getAttribute("tara_Condition").addOnChange(populateTextbox);

[Jmanriquerios · Accepted solution]

Hi @TaraAssadipour 

You can use this code, you must adapt it to your data model

// Obtén una referencia al contexto del formulario
var formContext = executionContext.getFormContext(); // Pasa executionContext como parámetro en tu función

// Obtén el valor del campo lookup
var lookupValue = formContext.getAttribute("nombre_del_campo_lookup").getValue();

if (lookupValue != null) {
    // Obtén el ID del registro referenciado
    var recordId = lookupValue[0].id;

    // Realiza una solicitud a la API web para obtener el valor del campo relacionado
    Xrm.WebApi.retrieveRecord("nombre_de_la_tabla", recordId, "?$select=nombre_del_campo_relacionado").then(
        function success(result) {
            var fieldValue = result.nombre_del_campo_relacionado;
            // Haz algo con fieldValue aquí
        },
        function error(error) {
            // Maneja el error aquí
        }
    );
}

[gulshankhurana]

Hi @TaraAssadipour 

My approach to this is would be a no-code one -

either the good old Workflow (if you want the system to fetch the original condition instantaneously).

Below is an example where I want to fetch the 'Event Type' from the 'Event' table and copy this to the 'Event Type' field (I used the same name in the target table) in the Event Attendee table when an Event Attendee record is created or when the 'Event' lookup field value changes:

or power automate (if you can afford the users to wait a little whilst the flow run completes).

I hope this information helps.

Kind regards

Gulshan

Please give it a thumbs up 👍🏻 if you appreciate my efforts.

If my answer helped you resolve your issue then please also mark it as a solution ✅  so that it helps others experiencing the same problem.

[TaraAssadipour]

Thanks @gulshankhurana , it definitely sets the textbox to the lookup filed value. The problem is when I modify the text and save, it saves the original text and not the new one. For example I want to be able to update "Street Sweeping" to "Street sweeping123". When I press save it is "Street Sweeping".

[gulshankhurana]

You can keep it to when a record is created only then.

Kind regards 

Gulshan

Please give it a thumbs up 👍🏻 if you appreciate my efforts.

If my answer helped you resolve your issue then please also mark it as a solution ✅  so that it helps others experiencing the same problem..

[TaraAssadipour]

Thanks for yor reply. Imagine the user picks "Street Sweeping" then updates it to "Street sweeping123" and save. he comes back and change the lookup value from "Street Sweeping" to "abcd". The record was not created but updated, and there is no workflow to copy the new value to the textbox.