Unanswered

delegation warning the search part of this formula might not work correctly on large data sets

(0) Share

Report

Posted on by nagestiada

504

Search('PurchaseList',TextInput1.Text,"EID","PID","PList1")

I have this simple code above but getting an error "The search part of this formula might not work correctly on larger data set."

When I only have less than 100 rows.

Anyone know why and how can I fix it?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Do have a number field as part search. Also check if the delegation limit in the FILE.. Advance Setting... Delegation is less than 2000. If so increase it.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nagestiada ,
The Search() function is not Delegable, however with 100 rows, you can ignore the warning for now. If you are only looking for matching text (not text inside the field), you can use StartsWith(), with the added advantage of everything showing when the box is empty and filtering as you type. Make the Default of the box "" (empty string) and put this

Filter( 'PurchaseList', StartsWith(EID,TextInput1.Text) && StartsWith(PID,TextInput1.Text) && StartsWith(PList1,TextInput1.Text) )

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.
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

The ID is in text column in sharepoint, yeah I already made it to 2000 but still encountering same error.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use the approach by @WarrenBelz
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@nagestiada
A Power Automate flow connected to Power Apps can be used to search a SharePoint list with no delegation warnings:
https://matthewdevaney.com/power-apps-search-function-delegation-warning-workarounds/

There are also 3 more delegation workarounds for the Search function and you can see examples here:
https://www.matthewdevaney.com/power-apps-search-function-delegation-warning-workarounds/

1. StartsWith Function
2. Search + Filter Functions

3. Dataverse For Teams IN Operator