Skip to main content
Nintex Community Menu Bar

Validation Rule: Compare contents of Multi entry Person field to Single entry person field

  • October 1, 2020
  • 2 replies
  • 9 views

Forum|alt.badge.img+3

Hi Everyone,

 

I am wanting to do a validation on form submission to check to see that a person that has been entered in to a Multi person "Approvers" field is not present in the "Preparer" field.

 

This so the preparer cannot play a part in the Approval workflow.

 

I can get it to work if only one user is entered in to the "Approvers" field, and that user is the "Preparer", but as soon as I enter a second person in to the "Approvers" field, the validation no longer triggers.

 

This is what I have in the validation rule at the moment:
Preparer==Approvers

 

Thanks for you help

2 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 6, 2020
Hi

Try:
contains(Approvers,Preparer)

Forum|alt.badge.img+3
  • Author
  • October 8, 2020
Thanks Simon