Search not bringing back all results.

(0) Share

Report

Posted on by Vstar19

381

Hello.

I have data from a SPO list displayed as a Data Table. There are approx 400 items in the SPO List

I have a text box called txt_Search which should search the data table.

Here is my code to search

Sort(
Search(
'Datasource',
txt_WorkspaceSearch.Text,
"{Name}",
"Description"
),
Name,
Ascending
)

Search works Ok until i noticed that some results were not appearing, for e.g. i can scroll through the datatable and see a value called 'APP-Sales-Laptop'.. But when i try and search for APP-Sales-Laptop, search brings back 0 results.

I am getting a warning on the datatable saying "The search part of the formulae may not work correctly for large data sets'

In File Settings, my data row limit is set to 2000.

Does anyone know what the issue here is?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Sort(
Search(
'Datasource',
txt_WorkspaceSearch.Text,
"Name",
"Description"
),
Name,
Ascending
)

Other than the angular bracket around the name column i don't see any problem in your code. You can ignore delegation.
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this:

If(
IsBlank(txt_WorkspaceSearch.Text),
Sort('DataSource',Name, Ascending)
,
Search(Filter(Sort('DataSource',Name, Ascending), TextInput1.Text,"Name")
)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vstar19 ,

What you are getting is a delegation warning. If you are not expecting values above 2000 in the list you can try below code.
AppStart: ClearCollect(colDataTable,'Datasource'); Sort( Search( colDataTable, txt_WorkspaceSearch.Text, "Name", "Description" ), Name, Ascending )

Sometimes the search does not work great when it detects - in the text for this you can use Startswith function instead of Search.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.