Search box doesnt find anything :-(

[Anonymous]

Good Day,
Currently building my very first WebApp, with the help of youtube and various tutos.

Today, I’ve got my access db thats is properly converted to a webapp, but I encountered a little issue I didnt expect at this stage : on the webapp, the “Search” box doesnt seem to find anything at all 🙁
A brief description of my db : a basic table consisting of 17 fields and 26 entries.
Whatever the search I’m typing in, a customer name, an ID number, anything... the result will show blank 🙁
Could anyone explain please ? Have you encountered the same issue ?
Many thanks in anticipation!

[v-qiaqi-msft]

Hi@Anthony_D,

Based on the issue that you mentioned, do you want to filter the table based on the search box?

Could you please share a bit more about the scenario:

1. What is your data source, an Excel table?
2. Which control do you use to display and filter the data?
3. What is your formula, how you set the related Search() function?

I assume that you have an Excel table as data source, a Gallery to display and filter the data, a TextInput to search for the key word.

Here is my scenario, please take a try as below.

Connect OneDrive to your App.

Add a TextInput control.

Insert a Gallery and set the Items property as below:

Search(Table1,TextInput3.Text,"ID","CustomerName")  // Table is my table name in Excel.

Note: All the column type should be Text type only for that the Search() function only allows a column containing text or string to be searched.

Or you could use the StartsWith() function, set the Items property as follows:

Filter(Table1,StartsWith(ID,TextInput3.Text) Or StartsWith(CustomerName,TextInput3.Text))

Hope it could help.

Best Regards,

Qi

[Anonymous]

Good Day QI,

Thanks for your quick response.

Yes this is the scenario I'd like to run :

Table name : tblCustomer

Targeted field/colomn : CompanyName

When typing any Company name, I am expecting to display the whole company details screen.

Example : in the Search Bar, if I am typing "ABC Corp" , I want my webapp to recognize "ABCP Corp" as a valid entry and open the whole "ABC Corp" details window (contact details, website, people and so on...)

On the gallery, if I enter the function (Fx)  :

Search(tblCustomer, TextSearchBox1.Text, "CompanyName") I get a red cross stating "ParenClose" indicating the command is wrong....

Now, I am stuck at this level.

Can you assist please?

CHEERS^^

[Anonymous]

QI,

I followed your advise religiously, butI still get some error message that's confusing me:

>>>>    Search(tblClient; TextSearchBox1.Text; "NomSociété" )

Please open pictures here :

https://file.cloudbuilder.axians.com/d/496cf5521cd24ae29eca/

Thank you !!

[Anonymous]

Anyone please?

[v-qiaqi-msft · Accepted solution]

Hi@Anthony_D,

Sorry for the time zone and here we go.

Could you please check the formula I provided one more time and check which property I set for the formula?

Please find the Items property of your Gallery, and put the formula within it, check the scenario below:

The first screenshot means that if there is no key word within the search bar, the Gallery will display all the table.

The second screenshot means that if there is a key word within the search bar, the Gallery will display based on the search word.

Please modify your formula as below:

If(IsBlank(TextSearchbox1.Text),'tblCustomer',Search('tblCustomer',TextSearchbox1.Text,"CompanyName"))

Hope it could help.

Best Regards,

Qi

[Anonymous]

QI,

You are the man!

Now, my search bar works fine .... I am relieved !!!  🤗

Thank you ever so much for your kind assistance 🍻