Answered

How to validate multiple dropdowns

(0) Share

Report

Posted on by m15433b

As the title implies, my customized Sharepoint form is using multiple dropdowns for data entry. I'm trying to validate the form to ensure that at least one of these dropdowns is not empty. This formula works for ONE dropdown:

If(IsBlank(Dropdown1.Selected.Value), Notify("You must fill out of one the dropdowns", NotificationType.Error,3000), SubmitForm(SharePointForm1))

However, if I modify it to this:

If(IsBlank(Dropdown1.Selected.Value) Or IsBlank(Dropdown2.Selected.Value), Notify("You must fill out of one the dropdowns", NotificationType.Error,3000), SubmitForm(SharePointForm1))

it's wanting to have both dropdowns (Dropdown1 and Dropdown2) to have value before it submits.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@m15433b

If(IsBlank(Dropdown1.Selected.Value) And IsBlank(Dropdown2.Selected.Value), Notify("You must fill out of one the dropdowns", NotificationType.Error,3000), SubmitForm(SharePointForm1))

Was this reply helpful? Yes No
m15433b 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion, but doesn't the 'And' operator (instead of 'Or') imply that both dropdowns need to have value? I want the form to validate as long as there is at least one dropdown that is not blank.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If( !IsBlank(Dropdown1.Selected.Value) Or !IsBlank(Dropdown2.Selected.Value),SubmitForm(SharePointForm1), Notify("You must fill out of one the dropdowns", NotificationType.Error,3000) )

@m15433b

Isn't that what the AND statement says, if both are blank, then send the notification, otherwise submit the form.

Was this reply helpful? Yes No
m15433b 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I was thinking of this: !IsBlanlk(....). I tried your suggestion it and it works. The whole time I had the conditions backwards! Thanks for your help. Will mark your answer as the solution.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Rick, I am stuck. I have two dropdowns in my app Preparer and Reviewer. This form was once upon a time an InfoPath form and the rule for the Reviewer field was "If Reviewer equals Preparer or Preparer is blank then disable. Now that I have recreated it in power apps I can not seem to get this to work. I have tried the following "IsMatch(DataCardValue8.Selected.Value,
Notify("Preparer and Reviewer can not be the same.") I put this in the On Select. Can you point me in the right direction?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

If you have a new question, post it rather than piggy-backing on an already answered question. No one will find it otherwise.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

If you have a new question, post it rather than piggy-backing on an already answered question. No one will find it otherwise.

Was this reply helpful? Yes No