Delegation Warning

(0) Share

Report

Posted on by NP-29072018-0

Explain what I need to do like I'm slow.

None of the links on the right go anywhere.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @NP-29072018-0,

Can you please remember to post your code in Text - saves re-typing here. The issue you have is that the Search function is not Delegable - so this

Search( [@'Pre Reg3 Audit'], SearchInputl.Text, 'Account Number' )

will only access the first 500 (can be increased to 2,000 in Data Row Limit ) records.

This is Delegable
Filter( [@'Pre Reg3 Audit'], StartsWith( 'Account Number', SearchInputl.Text ) )

and will access all matching records, but will only address the start of the field matching the characters entered. If you can "pre-filter" the list to under 2,000 records with another Delegable filter, you may be able to use Search()
With( { _Data: Filter( [@'Pre Reg3 Audit'], YourDelegableFilterHere ) }, Search( _Data, SearchInputl.Text, 'Account Number' ) )

Please click Does this answer your question 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 a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @NP-29072018-0, based on the image provided and question, I think you're questioning about what is delegation.

Answer :

Delegation in Power Apps means letting the data source (like SharePoint, SQL, Dataverse) handle filtering, sorting, or calculations instead of downloading all the data to the app and doing it there. This helps your app run faster and work with large data sets without hitting limits (like the 500 or 2000 row limit). You just need to use delegable functions and operators that the data source supports—otherwise, Power Apps brings all the data locally, which can slow things down or miss some records. Think of it as “asking the data source to do the heavy lifting.”

And the search function is not delegable and that is why you are getting the warning.

And, the formula suggested by Warren, will work with delegation.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI @NP-29072018-0

Resolving your Delegation warning may not be possible.

1) Is the Account Number text or a number?

2) How many records are you going to have in total in your Pre Reg3 Audit table do you think?

3) Is there any way to pre-filter the rows in Pre Reg3 Audit (like an Enabled or Status column so we can reduce the number of possible rows) prior to your Search ?

Was this reply helpful? Yes No
NP-29072018-0 15 on at

Like (0)

Report
Copy link

Link copied!

Sorry for not copying any of the code, I was not sure if the data in the formula bar was everything or if I was even in the right place to see what the error message was about.

Anyway, if I am understanding, that search will come back with up to 500 items where the Account Number searched matches. so my test data is '123456' and if I were to search for it, it could pull up the first 500 times that account number is used exactly?

There is no way that we would use the same number more than 500 times (or honestly more than 10 even) so this should not be an issue for me on this list.

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @NP-29072018-0, Search only examines the first 500 records (can be increased up to 2,000), and it returns any matches it finds there. So if ‘123456’ appears 10 times in your full set but only 3 times among those first 500/2000 rows, you’ll see just those 3 results not all 10.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @NP-29072018-0,

I have a blog on Delegation that may be useful - you really need to understand the concept before you start designing data structures and queries, or you will experience a lot of frustration.

When a query is not Delegable, SharePoint (or any other data source) sends back the first 500 (can be increased to 2,000 with Data Row Limit ) records for Power Apps to action "locally" - so you are only going to receive the results from the first 500 -2,000 records. There is no access to the rest of the records.

I gave an alternative using StartsWith in my post and unless you can "pre-filter" (example also in the post), this is all you are going to be able to achive.

Please click Does this answer your question 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 a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @NP-29072018-0

This is specific to @Power Apps 1919 as @WarrenBelz clarified.

Delegation does NOT search anything, it gives you back the first 500-2000 (depending on your configuration) based on how that datasource stores them (in order).

So truly just wanted to clarify for @Power Apps 1919

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Michael E. Gernaey,

My apologies for the confusion,I meant to say that the Search function itself is non-delegable, so it only evaluates the first 500 records by default (up to 2,000 if you bump the limit). I was simply trying to highlight that limitation on Search with an example. Thanks for helping clarify!

Was this reply helpful? Yes No
NP-29072018-0 15 on at

Like (0)

Report
Copy link

Link copied!

Hmm, how could I set it up so that it would only pullback the items that were created in the last 30 days? I think that would be under 500

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @NP-29072018-0,

Put this at screen OnVisible
UpdateContext({varDate: Today() - 30})

and then this in your filter
With( { _Data: Filter( [@'Pre Reg3 Audit'], Created >= varDate ) }, Search( _Data, SearchInput1.Text, 'Account Number' ) )

This is what I was referring to before regarding "pre-filtering"

Please click Does this answer your question 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 a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No