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?
Solved! Go to Solution.
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):
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.
Try
Search(Table1,Value(TextSearchBox1.text), "ID")
or
Search(Table1,Number(TextSearchBox1.text), "ID")?
Sean
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):
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.