xrm.navigation.openform set lookup field automatically from the previous form

(0) Share

Report

Posted on by Omar Bouattour

I added a new button inside my "Parcours" form that takes me to another form "Question" with a xrm.navigation.openform

The "Question" form has a lookup field from "Parcours" that I want to populate set automatically from the previous form like this for example :

This is my code for my button, I want to detect the ID of the parcours automaticly and set it in the new "Question" form

function NavigateQuestion(){
    var entityFormOptions = {};
entityFormOptions["entityName"] = "zs_question";
var formParameters = {};

// Set lookup column
formParameters["zs_parcours"] = ""; // I want to put the ID here from the previous form.
formParameters["zs_parcoursname"] = ""; // Name of the parcours.
formParameters["zs_parcourstype"] = "zs_parcours"; // Table name. 

Xrm.Navigation.openForm(entityFormOptions, formParameters).then(
    function (success) {
        console.log(success);
        console.log(formParameters);
    },
    function (error) {
        console.log(error);
    });


}

I have the same question (0)

All responses (3)

Answers (0)

Pradeep Rai 5,489 Moderator on at

Like (1)

Report

Hi,

If i understand it correctly then on "Parcours" entity form, you have added Ribbon Button to open the "Question" entity records.
Now, on "Question" entity you have a lookup field of "Parcours" entity. and you want the "Parcours" entity Id.

To achieve this please follow below steps:

1. On Ribbon button add one Parameters as shown in below screenshot:
d365demystified.com/.../

2. In your JS file you can use below code get the "Parcours" record Id:
formContext.data.entity.getId();

FormContext you will get from first step.

Now, you have the "Parcours" entity id with you and you can add this in your above code.

Thanks,
Pradeep.

Please mark this as VERIFIED. if it helps.
Pradeep Rai 5,489 Moderator on at

Like (1)

Report

Add on to above

One question i have, As per the above screenshots 1 Parcours can have multiple Questions.

Which mean we have 1:N relationship between them.

So, why you are creating new ribbon to open the Question records. You can use Related Tab or You can add subgrid of Questions entity on "Parcours".

With OOB way you can use Quick Create and Main form to fill the details. here, you can use the Relation Mapping concept to prepopulate the field values.

Thanks,

Pradeep.
Community Member on at

Like (1)

Report

Hi Omar Bouattour,

As Pradeep Rai said, you can get FormContext first and then use getEntityReference() to get lookup value of Parcours.(API: https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/formcontext-data-entity/getentityreference).

Here is a thread which is same as the things you are doing(If I don't misunderstand), you can refer to it:

community.dynamics.com/.../how-to-pass-javascript-entity-1-record-data-via-extraq-parameters-to-entity-2-via-javascript-by-means-of-add-new-record-subgrid

Join the conversation

Community site session details

xrm.navigation.openform set lookup field automatically from the previous form

Helpful resources

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

xrm.navigation.openform set lookup field automatically from the previous form

Helpful resources

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