When option selected from dropdown - Textbox MUST have value exceeding 0

(0) Share

Report

Posted on by cameron12

Hello, I’m very new to Powerapps.

I was wondering if someone could please help me with how I would be able to do this!

I need to make it so that when “YES” is selected in the drop-down option for “BOBS”, that the “No. Individuals field must have a value equal to 1 OR more. If value was under 1, display an error message that states “Error – Value must exceed 0”

The BOBS dropdown has been created in excel as a simple column 2 option table.

For this example in the code, please refer to the dropdown as ‘BOBSyesno’ and No.Individuals as ‘No.Individuals’.

I have attached a PDF displaying the screen.

Thankyou!

bobsyesno soultio...

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cameron12 ,

Please try this:
OnSelect of drop down:
If(DropdownName.Selected.Value/ColumnName="YES"&&Value(TextInputName.Text)<1,Notify("Value must exceed 0 in NO.Individuals field"))

Best regards,
Rimmon

Was this reply helpful? Yes No
cameron12 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Rimmon, thanks for your reply. I tried the code and it won't let me do the Selected.Value part, it will only let me say Selected.Coloumn1 for it to not be an error. Is this to do with how the EXCEL is set up?

when i did the coloum1 part, the code doesn't have an error however, when i enter 0 in the field and move on there is no error message appearing.

thanks

If(Bobyesno.Selected.Column1="YES"&&Value(Numberofindividualstext.Text)<1,Error("Value must exceed 0 in No. Individuals field"))

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
The items of my dropdown is a table which has a column named "Value", this is why I used "Value" in the code. Replacing it with your column name works just as well.

Best regards,
Rimmon

Was this reply helpful? Yes No
cameron12 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Rimmon,

Doest seem to want to work for me unfortunately, there is no error message or box highlighted etc. Could this be because I haven't set up the submission button or are they all independent?
or
Is it something to do with my excel table? perhaps you could show me a screenshot of what yours looks like? I've tried going with both options in 1 column and both options over 2 columns.

thankyou very much!

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Sure.
I modified my code.
This is my test:
When I select "YES", there will be a notify.
Or you can put this code on the OnChange property of the TextInput.
If(Bobyesno.Selected.Column1="YES"&&Value(Numberofindividualstext.Text)<1,Notify("Value must exceed 0 in No. Individuals field"))

Rimmon

Was this reply helpful? Yes No
cameron12 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome! that worked! thankyou, is there any way to either make the alert in the middle of the screen or for the text box to have a red * representing the error?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Please modify the code as:
If(Bobyesno.Selected.Column1="YES"&&Value(Numberofindividualstext.Text)<1,Notify("Value must exceed 0 in No. Individuals field")&&Set(var,Color.Red),Set(var,Color.AliceBlue))

If my answer help solve your problem, please accept it as a solution.
Thanks!😀
Rimmon

Was this reply helpful? Yes No