Unanswered

Search bar problems

(0) Share

Report

Posted on by ProtoSup

Hi everyone, I have a power apps app for management stocks with a lot of items. In the home page there is a search bar who search on the title field but now many items are unreachable.

I know this formula is depreciate but I don't have another ideaes to do global search on all the items

Here is the formula : Search([@MyList];MySearchBox.Text;"Title");

Just to be clear : I have another screen "Specific search" where I make the user choose on category an secondly the searchbar become visible and user can make a search on items previously filtered by category.

This search type works really good but I mus have a global search on the home page but I have no solutions

Please any advices or ways to fix my problem ?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @ProtoSup ,

Do you mean that search for multiple columns?
Please try this:
Search(List;SearchBox.Text;"ColumnName1";"ColumnName2";...)

Best regards,
Rimmon

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report
Copy link

Link copied!

@v-mengmli-msft I want to search only on the Title column. Do you see my problem ?

I think there are too many items in my list and therefore in my research action...

Any advices ?

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

Like (1)

Report
Copy link

Link copied!

Hi @ProtoSup ,

I don't think I understand your question very well, if the "global search" in your question refers to finding all the records that match the condition, then you need to note that search is not a delegable function. If your data source is large, search will only return a subset of the results that match the condition. If your data source is less than 2,000, then I recommend you increase the data limit in the settings.

Best regards,
Rimmon

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report
Copy link

Link copied!

@v-mengmli-msft

Hi,
my problem is that I have 3119 elements in my sharepoint list and I want to do a search among all the elements BUT: When I have to search with the search function in the 3119 elements sometimes I do not find certain elements whereas when I search via another more selective interface everything works well.
In my other interface I make a first filter yes I make the search bar appear so there are not as many elements...
Do you understand ?
THANKS

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

Like (0)

Report
Copy link

Link copied!

Hi @ProtoSup ,

As your data exceeds the delegated limit of Search function, if you insist on using the Search function, it is necessary to use a delegable function such as filter to filter a portion of the data first. Of course, you can also use the StartsWith function, which is delegable.

Best regards,
Rimmon

Was this reply helpful? Yes No