Answered

Search function returning column not valid

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@KBADM

Could you post a screenshot showing the formula and the error message please?
KBADM 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp

Sure screenshot attached.

Thanks
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

@AnonymousOk so will add in a few batches the errors
KBADM 18 on at

Like
a
(0)

Report
Copy link

Link copied!

2nd
KBADM 18 on at

Like
a
(0)

Report
Copy link

Link copied!

3rd