Unanswered

Search bar problems

Like (0) Share

Report

Posted on 7 Dec 2023 09:57:07 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:

Using Apps Using Formulas

Connectors

Connecting to Data

General Questions

I have the same question (0)

All responses (5)

Answers (0)

v-mengmli-msft on 11 Dec 2023 at 07:57:45

Like (0)

Report

Re: Search bar problems

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
ProtoSup on 08 Dec 2023 at 13:05:29

Like (0)

Report

Re: Search bar problems

@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 08 Dec 2023 at 10:10:45

Like (1)

Report

Re: Search bar problems

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 07 Dec 2023 at 12:33:37

Like (0)

Report

Re: Search bar problems

@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 07 Dec 2023 at 10:04:38

Like (0)

Report
Re: Search bar problems

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