Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I am new to Dynamics CRM 365.
I have a lookup field on my entity 'oppurtunity' and i like to show it as a dropdown. Is this possible? If so, please suggest the steps.
Infact I have 2 lookups to show as dropdowns.
Say Country and City lookup fields.
When the user choose a particular country, the City dropdown should automatically filter and show only cities that belong to a given country. I am hoping, this is possible. Please suggest steps to create this.
I would suggest you to apply custom filer rather than creating lookup as dropdown list.
Please refer below url reference:
I created 2 entities Country and City
City entity has a field Country as a lookup data type mapped to Country entity
On opportunity form added 2 fields Country and City
Changed Properties of City field and enabled "Related Records Filtering"
Then Selected "Only Show Records Where" -> Country (Opportunities)
Then Select "Contains" -> City (Opportunities)
This seem to have worked, it displays related cities when selecting a particular country on the Opportunity form.
Do you see any issues with this approach?
By the way, is there a work around to display these fields as Drop downs and still have the filtering applied?
You should have to use OOB functionality rather than creating drop down list.
Do you see any issues with this approach? This is right approach actually, I dont think so you could face any issue.
Your approach is correct , in addition you can create a business rule to lock the city until country lookup fill the data.
I describe all the steps in below video , hope this helps -
Thank you Pravin
Great video Goutam. Helps a lot. Thanks for suggesting lock/unlock with Business rule.
So, there isn't a way to show the lookup as a dropdown? or is not a best practice? One of my solutions requires showing these look up fields as dropdowns as per client's requirement. Any suggestions will be appreciated.
I am happy to accept OOB is the best practice, but like to hear if there are alternatives and limitations that comes with that option.
There is no way to display the lookups field as the dropdown. The related record filtering for lookup is the best way to use.
Business Applications communities