Unanswered

Unable to search a list

(0) Share

Report

Posted on by AaronHB

So, I have a list that is bringing data from a sharepoint list. I have it set up so that the title and subtitle are shown in the list. The columns that are used for the data Ttile being the Title column and subtile being the When column.

I have placed a text input, and used "Search(Inventory,TextInput1.Text,Title)" it all works until i get tot he column part of the function where it does not find the column, I have also tried to use the lable where the Title will be and it throws an error saying the the data type should be control.

If anyone has any ideas that would be great, and feel free to ask if you want more information.

Categories:

Building Power Apps

msedge_2019-10-17...

I have the same question (0)

All responses (9)

Answers (1)

mdevaney 29,989 Moderator on at

Like (1)

Report
@AaronHB
One thing that I noticed right away was the quotes are missing from your 3rd argument passed to SEARCH. Try this and let me know if it works.

Search(Inventory,TextInput1.Text,"Title")

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
AaronHB 24 on at

Like (0)

Report

Unfortunately this did not work, Do I have to link the gallery list to the search or will it do it automatically?
@mdevaney

Aaron

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report

Hi @AaronHB ,

The formula that @mdevaney provided should work. Did you make sure that your search box control's name is TextInput1? And the column that you are searching on is named "Title"?

Regards,

Mona

Was this reply helpful? Yes No
AaronHB 24 on at

Like (0)

Report

Well the Column that I want to search is called Barcode but when I enter that it says that it does not exist as a column, yet when I scan I use the column barcode. And yes the text input is correct.
@v-monli-msft
Aaron

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

What is "Inventory"? A Sharepoint List or a Collection? If its a Sharepoint list please take a screenshot showing us the Barcode column. If its a Collection, please take a screen shot of the "Collections" menu screen showing the Barcode column. Now that the syntax of the formula is correct we need to understand why Barcode is not in Inventory.

Was this reply helpful? Yes No
AaronHB 24 on at

Like (0)

Report

@mdevaney

It is a sharepoint list.

Aaron

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@AaronHB
Was the Barcode column added after your app was designed? Please try a refresh of the datasource on your left-side menu. This is usually the cause of the same problem for me.

I have a few more questions if my Refresh suggestion does not work
* What data type is the monitor column?
* Can you please show me TextInput1 in a screenshot?

Was this reply helpful? Yes No
AaronHB 24 on at

Like (0)

Report

@mdevaney

I have refreshed it multiple times and it still does not show.

The barcode column is a single line of text.

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@AaronHB
The screenshot is quite helpful. I think I know the issue. You are using this code in the Default property of TextInput1. Search returns a table but a Textbox only accepts a single text value.

Search(Inventory,TextInput1.Text,"Title")

To show the results of a search in the gallery please remove this line from the Default property of TextInput1 and put it in the Items property of your gallery instead.

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No