cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShanP
Advocate II
Advocate II

Search only returning string values, need integer

Search(Table1,TextSearchBox1.text, "ID")

 

I am using the above code for most of my app and it works fine when the column is based on strings and not numbers. I have one column that is counting something, so it is a number. I can't find how to call this for the search function. Do I need to put in TextSearchBox1.Value?

1 ACCEPTED SOLUTION

Accepted Solutions
CarlosFigueira
Power Apps
Power Apps

The Search function only works for text-based columns. If I try to use it in my database for a numeric column, I get the following error (and hover on the "Id" column name):

ForumPost001.PNG

You can use the Filter function to accomplish a similar thing:

Filter('[blog20170901].[Accounts]', TextInput1.Text in Text(Id))

Which may not be exactly what you want for a numeric column - this will filter the data source for values which contain the given text. For example, if TextInput1.Text is "2" (without quotes), it will return rows where the Id is 2, 123, 432, and so on. You can also use the comparison operators (=, <>, <, >, <=, >=) to make numeric comparisons, such as

Filter('[blog20170901].[Accounts]', Value(TextInput1.Text) > Id)

Which will return all rows where the id is value of the text input is larger than the id.

View solution in original post

2 REPLIES 2
bean
Continued Contributor
Continued Contributor

Try

 

Search(Table1,Value(TextSearchBox1.text), "ID")

 

or

 

Search(Table1,Number(TextSearchBox1.text), "ID")?

 

Sean

CarlosFigueira
Power Apps
Power Apps

The Search function only works for text-based columns. If I try to use it in my database for a numeric column, I get the following error (and hover on the "Id" column name):

ForumPost001.PNG

You can use the Filter function to accomplish a similar thing:

Filter('[blog20170901].[Accounts]', TextInput1.Text in Text(Id))

Which may not be exactly what you want for a numeric column - this will filter the data source for values which contain the given text. For example, if TextInput1.Text is "2" (without quotes), it will return rows where the Id is 2, 123, 432, and so on. You can also use the comparison operators (=, <>, <, >, <=, >=) to make numeric comparisons, such as

Filter('[blog20170901].[Accounts]', Value(TextInput1.Text) > Id)

Which will return all rows where the id is value of the text input is larger than the id.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (58,448)