cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Courtney
Level: Powered On

Button Visible If number is lover than

Hi all.

 

So I have 3 text entry boxes. 

 

If any of the boxes has a number lower than 5 entered I would like the button to become visible. 

 

1.png

 

If the number entered is anything higher than 5 it should remain invisible. 

 

Any ideas on this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Button Visible If number is lover than

Hey Courtney,

 

Matthew got you most of the way there, but I think I see what you're looking for:

 

 

 

 

If(
   (!(IsBlank(TextInput1a.Text)) && Value(TextInput1a.Text) < 5)
   ||
   (!(IsBlank(TextInput2a.Text)) && Value(TextInput2a.Text) < 5)
   ||
   (!(IsBlank(TextInput3a.Text)) && Value(TextInput3a.Text) < 5)
   ,
   true
   ,
   false
)

 

 

 

 

I've attached a POC app, make sure your inputs have a default value that is empty 🙂

 

Cheers,

Sancho




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Button Visible If number is lover than

@Courtney
Put this code in the Visible property of the button.

Value(TextInput1a.Text) < 5 Or Value(TextInput2a.Text) < 5 Or Value(TextInput3a.Text) < 5

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
Courtney
Level: Powered On

Re: Button Visible If number is lover than

Thanks for your response. 

 

I tried your formula plus the one below and the button remains visible. 

If(Value(TextInput1a.Text) < 5 Or Value(TextInput2a.Text) < 5 Or Value(TextInput3a.Text) < 5, true,false)

 

I'd only want it to show if any of the text boxes have a number lower than 5 entered. 

Super User
Super User

Re: Button Visible If number is lover than

@Courtney 

I misread your original post.  Try this in the Visible property of the button.  Do not use any if statement.

 

Value(TextInput1a.Text) > 5 Or Value(TextInput2a.Text) > 5 Or Value(TextInput3a.Text) > 5

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

Courtney
Level: Powered On

Re: Button Visible If number is lover than

The formula is accepted but will remain visible no matter the condition. Adding the IF seems to work but the button will remain visible until a number of 5 or more is entered. I'd like the button to be invisible until it detects a number of 4 or less. 

Super User
Super User

Re: Button Visible If number is lover than

Hey Courtney,

 

Matthew got you most of the way there, but I think I see what you're looking for:

 

 

 

 

If(
   (!(IsBlank(TextInput1a.Text)) && Value(TextInput1a.Text) < 5)
   ||
   (!(IsBlank(TextInput2a.Text)) && Value(TextInput2a.Text) < 5)
   ||
   (!(IsBlank(TextInput3a.Text)) && Value(TextInput3a.Text) < 5)
   ,
   true
   ,
   false
)

 

 

 

 

I've attached a POC app, make sure your inputs have a default value that is empty 🙂

 

Cheers,

Sancho




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

Highlighted
Super User
Super User

Re: Button Visible If number is lover than

Updated my previous post, thanks to @mdevaney for pointing out the input names were duplicated! Legend as always 😺




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!
Super User
Super User

Re: Button Visible If number is lover than

@iAm_ManCat 

No problem at all

 

@Courtney 
If the post of @iAm_ManCat works for you please mark it as the solution 🙂

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,645)