Hello,
HELP!! I'm trying to add validation to a people control based on several conditions met. The formula below works as expected; it red lines the required people control and the validation message appears; however, when I try to submit, the validation message and red line remain and I'm not able to submit the form. Is there something wrong with my formula? What am I missing?
and(contains(ControlName1, "Choice Value") ,or(equals(BusinessUnit,"Business Value A "), or(equals(BusinessUnit,"Business Value B"),equals(BusinessUnit, "Business Value C"),isNullOrEmpty({Self}))))
Solved! Go to Solution.
if I try to prettify your formula to be a bit more visually understandable I get following
and(
contains(ControlName1, "Choice Value") ,
or(
equals(BusinessUnit,"Business Value A "),
or(
equals(BusinessUnit,"Business Value B"),
equals(BusinessUnit, "Business Value C"),
isNullOrEmpty({Self})
)
)
)
what reveals that for innermost OR you specified 3 arguments which is not syntactically correct.