cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tezz233
Helper II
Helper II

Check if textbox is number

ID_Code = TextInput1.Text

 

If I enter a string such as "ABC" into TextInput1, the above code will tell me if he user input (ABC) exists in the database's ID_Code column. Is there a way to get this to work with numbers? For example, if I type 123 into TextInput1, the code should check that specific input to see if it exists in the database. I had a look into casting, but couldn't get anything to work.

2 ACCEPTED SOLUTIONS

Accepted Solutions
bean
Continued Contributor
Continued Contributor

To cast the textbox value to a number simply use this

 

Number(TextInput1.Text)

Good luck

Sean

View solution in original post

CarlosFigueira
Power Apps
Power Apps

As @bean suggested, if you need to compare the value of a text box to a numeric column in your data source, you should convert it to a number first - using the Value function. For example, you can have a gallery with this expression for its Items property:

Filter(MyDataSource, ID_Code = Value(TextInput1.Text))

View solution in original post

4 REPLIES 4
bean
Continued Contributor
Continued Contributor

Does this help?

 

If(IsNumeric(TextInput1.Text), "Number", "Alphanumeric")

Sean

bean
Continued Contributor
Continued Contributor

If you could provide more detail on what you're trying to do that will help more.

 

Cheers

bean
Continued Contributor
Continued Contributor

To cast the textbox value to a number simply use this

 

Number(TextInput1.Text)

Good luck

Sean

CarlosFigueira
Power Apps
Power Apps

As @bean suggested, if you need to compare the value of a text box to a numeric column in your data source, you should convert it to a number first - using the Value function. For example, you can have a gallery with this expression for its Items property:

Filter(MyDataSource, ID_Code = Value(TextInput1.Text))

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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