Nested and validation statements Ninitex form

+2

Hi folks,

I'm a newbie on here and to SharePoint and I've got an issue with nested and statements in a validation rule.

Basically, I want an error message to be thrown if

1. Amount from a dropdown is in Euro

2. The Budget is > 125000

3. The Director field is empty.

This validation rule is on the director field.

What I've got is Control is invalid if :

and(and(equals(EuroOrSterling, "€"), greaterThan(BudgetAmount, 125000)), isNullOrEmpty({Self}))

But it isn't working.

Anybody able to help?

Thanks in advance.

+11

For dropdown values you need to put it inside a parseLookup:

and(and(equals(parseLookup(EuroOrSterling), "€"), greaterThan(BudgetAmount, 125000)), isNullOrEmpty({Self}))

Sign up