Customer experience | Sales, Customer Insights,...

Cascading Lookup to be Configured

(1) Share

Report

Posted on by sandeepc

5,476

Hi All,

I have a requirement where i need to create a cascading dropdown fields.

I press the lookup on Team 1 field, I choose the first Team 1 values example Credit , I will then see the linked values for Credit i.e. ABC, DEF, I then select say ABC.

What I should then see populated in my two fields on the form are:

Trading Team 1 = Credit

Trading Team 2 = ABC

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Cascading Lookup to be Configured

Hi Partner,

In the form, You can configure lookup column properties:

--Filter by related rows: When this is enabled, you can filter this lookup based on a row related to both the current table and this lookup.

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/form-designer-add-configure-lookup#configure-a-lookup-component

Please refer to the following links for examples:

https://thedynamicspirate.co.uk/filter-lookups-by-related-records-in-model-driven-apps/

https://softchief.com/2022/10/21/filter-lookup-values-by-another-lookup-value-in-dynamics-365-or-dataverse-power-apps-form/

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah
sandeepc 5,476 on at

Like (0)

Report

Cascading Lookup to be Configured

Any Update

I am using opportunity entity and the records are not displaying