Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to add a condition...
Customer experience | Sales, Customer Insights,...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by CHK1970 560
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
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    How to add a condition to Region/state "Look-up field" based on select "Country" Look-up field
    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!
  • Suggested answer
    Fiona_Tiernan Profile Picture
    Fiona_Tiernan 384 Super User 2025 Season 1 on at
    How to add a condition to Region/state "Look-up field" based on select "Country" Look-up field
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,762 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans