Customer experience | Sales, Customer Insights,...

Cascading Lookup to be Configured

(1) Share

Report

Posted on by sandeepc

5,514

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

I have the same question (0)

All responses (2)

Answers (0)

sandeepc 5,514 on at

Like (0)

Report

Any Update

I am using opportunity entity and the records are not displaying

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cascading Lookup to be Configured

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

Cascading Lookup to be Configured

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