Unanswered

How to fix Delegation Warning for Dataverse

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all. I'm still a beginner and would appreciate if someone can help me to solve this problem.

I have a search function that will display list of people by typing the department name. It works fine but I noticed that the number of people it shows does not same with the actual number. Anyway, I have 4000+ rows in GBS data source.

I got a Delegation warning: This part "Filter" of this formula might not work correctly on large data sets starting from IsBlank line until before SortPriority line. Does this delegation affect the number of records retrieved?

If(
 Len(TextSearchBox.Text) > 0,
 SortByColumns(
 Filter(
 GBS,
 IsBlank(
 Find(
 "0",
 Concat(
 Filter(
 Split(
 TextSearchBox.Text,
 " "
 ),
 !IsBlank(Result)
 ),
 If(
 TrimEnds(Result) in department,
 "1",
 "0"
 )
 )
 )
 )
 ),
 SortPriority, If(SortDescending, Ascending, Descending))
)

I'm not sure how to fix this. Hope someone could help me to solve this.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Yes, delegation limits the number of records fetched by PowerApps. The default is 500. You can increase it to 2000. Now coming to your problem, could you explain what you are trying to do within the,

IsBlank(Find("0",Concat(Filter(Split.................
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT I want to search keywords in department column including the spaces and hyphen (-).
For deeper explanation you may refer to the reply by @/CalfordMath in this link https://powerusers.microsoft.com/t5/Building-Power-Apps/Searching-with-multiple-key-words/m-p/376698/highlight/true#M108986