News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... dependent fields

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

dependent fields

(0) Share

Report

Report

Posted on by PersianBoy

20

hi

i want to create dependent field , like state and country in CRM

how can i create?

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Henry J. 5,237 on at

Like (0)

Report

RE: dependent fields

One other alternative: use of a Power Apps Component Framework (PCF) control.
See: https://pcf.gallery/dependent-optionset/
Verified answer

Henry J. 5,237 on at

Like (1)

Report
RE: dependent fields

Hello,

There are several ways to look at it:

If you have created "State" and "Country" entities in your data model, then you can easily make the user first select a Country before they select a State, and filter the State based on the associated Country.
You could even add a business rules to make sure that the Country is selected before the State field becomes editable, or to make sure that the Country becomes read-only once a state has been selected.
This article details that approach: https://www.powerobjects.com/blog/2016/03/15/how-to-use-dependent-lookups-for-dynamics-crm-201320152016/

If you have created "States" and "Countries" as option-sets, you might want to implement dependent option-set logic.
You can do so with custom JavaScript code (e.g. https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg594433(v=crm.8))
Have also a look at: https://crmoptionsets.azurewebsites.net/

As a side note if you are looking for a out-of-the-box no-code approach for dependent option-sets, you might want to wait to see the content of the upcoming 2020 Release Wave 1.
As a matter of fact, dependent option-sets is a feature that has been postponed twice already.

https://docs.microsoft.com/en-us/business-applications-release-notes/april19/change-history#features-removed-from-release-notes-13

https://docs.microsoft.com/en-us/business-applications-release-notes/october18/change-history#features-removed-from-release-notes-6

Check out this blog for the key dates and resources for the 2020 Release Wave 1: https://cloudblogs.microsoft.com/dynamics365/bdm/2019/12/16/dynamics-365-and-power-platform-timeline-for-the-2020-release-wave-1/

Henry

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,202 Super User 2025 Season 1

#2

Martin Dráb 231,923 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans