web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Comparing two fields with a If condition in a process workflow

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Sreevalli Profile Picture
    3,256 on at

    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.

  • Suggested answer
    Community Member Profile Picture
    on at

    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

  • Community Member Profile Picture
    on at

    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

  • Community Member Profile Picture
    on at

    Hi,

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

  • Suggested answer
    Sreevalli Profile Picture
    3,256 on at

    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

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    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.

    .

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans