Unanswered

When searching through a text input, the gallery returns blank

(0) Share

Report

Posted on by emily_nicole

Hello, I have connected my Power App to a table in Excel Online for business. I have inserted a vertical gallery, which does populate all of the table data. However, I cannot get the search on the text input to work for some reason. I have followed these exact steps before (like yesterday) with a different table/document and it worked.

The Items property of the gallery is: Search(Table1, TextInput1.Text, "Network ID")

Table 1 is the data source, TextInput1.Text is of course the text input box, and Network ID is the title of the column in excel. The gallery shows all rows from excel, but when searching for a network id, it returns blank. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @emily_nicole

Check that the "Network ID" column in Excel contains text data. The Search function works on text fields, so if the column is formatted differently in Excel (e.g., as a number or a date), the search may not work as expected.

If everything seems to be correct and you're still facing issues, try using the Filter function with in or StartsWith to see if that works for your scenario:

Filter(Table1, TextInput1.Text in 'Network ID')

or

Filter(Table1, StartsWith('Network ID', TextInput1.Text))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
rhyspmurphy 34 on at

Like
a
(0)

Report
Copy link

Link copied!

So as you are importing from excel, I will assume the NetworkID field is numerical and therefore being in the table it is being treated as the Number data type.

You can get around this by using the AddColumns function create a new column for the table and converting the NetworkID number value to text.

The Items property of the gallery should use this:

Search(AddColumns(Table1, "NetworkIDText", Text(ThisRecord.NetworkID)), TextInput1.Text, "NetworkIDText", "Name")

Table 1 is the name of the excel data source.
We are adding a new column called "NetworkIDText".
We are adding a value to each row for the "NetworkIDText" that is NetworkID converted to Text with Text(ThisRecord.NetworkID).
We are the using a Text Input component as a search bar and getting the typed in value from TextInput1.Text.
We are the choosing which fields to Search by which has to be text type fields, in this case both "Name" which was a column already in my excel table and the newly created "NetworkIDText" which now contains the text value version of the network ID.

Code above may need tweaking to use the names of data sources and components in your app.

Let me know this goes and if it works please mark as a solution.

Was this reply helpful? Yes No