Personalized Community is here!
Quickly customize your community to find the content you seek.
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
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 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 | Upcoming TechTalks
Hello. I want to add conditions for a calculated field, but there's a problem. I need to check a value in a field (type "Search"), but there's no type of conditions to check value of this field (just check if contains data). So, my question: can I somehow check the value of the field (type "Search") in the condition of a calculated field, or is there any another solution?
Unfortunately, this is by design and we cannot use other conditions for the lookup field in the calculated field.
I would recommend that you create new fields as the lookup entity for the current entity.
For example, Quote has a "test 1" field. I want to create a calculated field "test 2" for Order. The condition is that if the "test 1" field value of the Quote lookup field is "abc", then I will set the "test 2" field value to "123".
In order to achieve this goal, we also need to create a calculated field "copy of test 1" for Order to get the field value of Quote.
The "copy of test 1" calculated field has only one action, which is equal to the "test 1" field value of Quote.
Then I use "copy of test 1" calculated field in the condition of "test 2" calculated field of Order.
This way, we can use the field value of the record of the lookup field as the condition.
Thank you, Lu Hao! This is helpful!
But what if I need check the value of some system field (option "Searchable" is No)? I can't use the "copy of test 1" calculated field because there's no option to action, whick is equal to the system field. What can I do in this situation?
These system fields are not available in the calculated field, so you have to write a plug-in.
Business Applications communities