Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Comparing two fields with a If condition in a process workflow

Posted on by Microsoft Employee

Hello,

I want to create to create a process background workflow, where I want to have a simple If condition,

It should simply compare the Primary Contact field from Account with the Full Name field from Contacts. But I can not select a field which I want to compare with, I can only select a specific contact via a lookup search.

To make the comparison vice-versa also does not work, compare the Full Name field from Contact equals with... only allows me to compare with a value which I manually enter, see screenshot below.

workflow-compare.PNG

Any ideas?

Thanks!

*This post is locked for comments

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Comparing two fields with a If condition in a process workflow

    Hello,

    Above Srevalli, already suggested you can not directly compare with full name with lookup as lookup internally taking  GUID reference. That's why primary contact I'd field not showing when you are comparing with text field.

    So instead of full name  you can directly compare with  the contact lookup.

    .

  • Suggested answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at
    RE: Comparing two fields with a If condition in a process workflow

    Hi,

    You cannot compare string with lookup value. if you want to compare with "Primary Contact" then you have to select "Contact" instead of Full Name.

    Screenshot-2019_2D00_01_2D00_11-at-8.14.46-PM.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Comparing two fields with a If condition in a process workflow

    Hi,

    Could you tell us what type of field is 'Primary Contact'?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Comparing two fields with a If condition in a process workflow

    Thank you. This was I was looking for, but almost.

    The field which I want to compare 'Full Name' from Contact with 'Primary Contact' from Account entity is missing in my list.

    Also missing when I want to compare it vice-versa.

    workflow-compare2.PNG

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Comparing two fields with a If condition in a process workflow

    Hi,

    The solution to your describe problem would be to use Dynamics Form Assistant. When you click on the value field, on the right side you would notice a Form Assistant. Select Dynamics value in the first field, then you can specify the Entity name and the field with which you would like to compare the value with. The same process could be useful for you if you want to assign one value from another entity.

    Refer to this book for more information: https://crmbook.powerobjects.com/system-administration/processes/workflows/

    Thanks

    Jay

  • Verified answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at
    RE: Comparing two fields with a If condition in a process workflow

    Hi,

    Click on input box and from the right side Form Assistance Look for Contact then Full Name field from the fields list and add to the input.

    Screenshot-2019_2D00_01_2D00_10-at-11.12.24-PM.png

    if you are not able to see Form Assistance or not able to save the changes then that should be browser issue, try to do the changes from IE or chrome.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans