Customer experience | Sales, Customer Insights,...

How to add a condition to Region/state "Look-up field" based on select "Country" Look-up field

(1) Share

Report

Posted on by CHK1970

562

We are using the Look-up fields on our RTM Form for Country & Region/State.

How can we apply a logic to only populate the Region/State Look-up field with those states/regions/provinces that are relevant to the selected Country?

Is there a way with look-up fields to build a relation between Active Country & Active Region/State ?

This has long been a problem and im hoping maybe with RTM this could be solved in a better way!

/Chris King

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Fiona_Tiernan 388 Moderator on at

Like (0)

Report

Hi Chris,

To my knowledge one way to achieve this OOTB would be to create 1:N relationships to then filter the lookup fields - I found this blog that provides a step by step guide using the Country vs City scenario - but the logic would work the same: https://carldesouza.com/filtering-lookup-fields-in-dynamics-365/

If this answer was helpful, please consider marking it as verified :) Any questions please let me know, and I will try my best to answer them!

Kind regards,
Fiona

Was this reply helpful? Yes No
Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report

Hey!
What you're looking for is usually referred to as "Dependant DropDown lists" or "Cascade DropDown lists". Microsoft's public information is on https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/dependent-drop-down-lists and curiously, it specifically states that situation: Selecting a country and showing only cities from such country.

YOu have a nice simple guide on https://powerapps.microsoft.com/en-us/blog/configure-easy-dependent-drop-downs-in-powerapps but the previous link from public documentation also has a nice Step-by-step guide.

Regards,

******
I hope this answer has helped you solve your problem. If you are satisfied with it, please consider marking it as the excellent answer by clicking on the green check mark below. This will help other users who have similar questions find the best solution.

Thank you for your feedback!

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to add a condition to Region/state "Look-up field" based on select "Country" Look-up field

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

How to add a condition to Region/state "Look-up field" based on select "Country" Look-up field

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