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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,907)