Search function returning column not valid

[KBADM]

New to using powerapps and run into the below issue with a simple app.. The app is pulling information from Excel sheet which contains account numbers and details.. The idea is to use it to search specific numbers then see the relevant info. The issue i have is searching the account number... I have the column and it pulls this as it lets me make this the main view and sort by it... However adding to the search function it fails and says it does not exist.

I have the below and it works... The moment i add AccountNumber it errors.

SortByColumns(Search([@Table1], TextSearchBox1.Text, "CompanyName","Seg_x002f_Non-Seg","Status"), "AccountNumber", If(SortDescending1, Descending, Ascending))

So below fails

SortByColumns(Search([@Table1], TextSearchBox1.Text, "CompanyName","AccountNumber","Seg_x002f_Non-Seg","Status"), "AccountNumber", If(SortDescending1, Descending, Ascending))

I cannot seem to figure out how to make this so i can search Account numbers..> This is the main thing that would be searched.

Thanks 

[Drrickryp]

@KBADM

Search only works for text. To find numbers you need to use Filter() and =, StartsWith(), or the "in" operator. 

SortByColumns(
                If(
                  IsNumeric(
                     TextSearchBox1.Text
                   ), Filter(
                        [@Table1], AccountNumber= Value(TextSearchBox1.Text),                    
                      Search(
                        [@Table1], TextSearchBox1.Text,"CompanyName",
                                                        "Seg_x002f_Non-Seg",
                                                         "Status"
                       )
                  ), AccountNumber, If(SortDescending1, Descending, Ascending)
)

[KBADM]

Thank, that makes sense... However still i get an error 'expected boolean. We expect a boolean (true/false) at this point in the formula.'

Thanks

[Drrickryp]

@KBADM 

Could you post a screenshot showing the formula and the error message please?

[KBADM]

@Drrickryp 

Sure screenshot attached.

Thanks

[Anonymous]

Hi, a possibillity is adding a combo-box with for the account numbers. This has a search function.
Then use a dependent dropdown to show only ComboBox_Name.Selected.Value, This is only if i understood what u are trying to do correctly.

[KBADM]

@Anonymousi am trying to make it so the users can then search the list by the account number. As this would be the primary search the other info can be used as well but main one is the numbers.

Thanks

[Anonymous]

Could u open up the AppChecker and send those errors? Also a monitor session could be helpful.

[KBADM]

@AnonymousOk so will add in a few batches the errors

[KBADM]

2nd