Delegation Warning in startswith function - Previous its working

(1) Share

Report

Posted on by Jawaharprem

272

Hi all,

facing delegation warning while using startswith function, previously i create many app with this method still now its working fine without any warning, now iam facing this delegation warning, how to resolve this..

With({wdata:Filter(CMD_NA_Tracker,StartsWith(Request_ID,TextInput1.Text))},
ClearCollect(colGridData,Filter(wdata,Assign.Value<>"Assigned")))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hey

If you're filtering on a single column and Request_ID is a text column, you can use the Search() function, which is delegable in SharePoint:

With( {wdata: Search(CMD_NA_Tracker, TextInput1.Text, "Request_ID")}, ClearCollect(colGridData, Filter(wdata, Assign.Value <> "Assigned")) )

if that helped please mark as verified answer,

thanks

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Pls try the following:

Go to Settings > Advanced Settings > Data row limit for non-delegable queries and increase the limit (up to 2000).

If your dataset is large, you can switch to a delegable function

With({wdata:Filter(CMD_NA_Tracker, Search(Request_ID, TextInput1.Text))},
ClearCollect(colGridData, Filter(wdata, Assign.Value <> "Assigned")))

hope this helps.

Was this reply helpful? Yes No
Jawaharprem 272 on at

Like (0)

Report
Copy link

Link copied!

thanks SaiRT14, row level i already increased to 2000, and used your code but getting error.

Was this reply helpful? Yes No
Jawaharprem 272 on at

Like (0)

Report
Copy link

Link copied!

hi mmbr1606, thanks for your time, the Request_ID is a column in sharepoint, the Textinput1.text is textinput used to search the id's, if changed as per my requirement, getting error... previously its working very fine now getting delegation warning, i checked with my IT Team no response...

Was this reply helpful? Yes No
Jawaharprem 272 on at

Like (0)

Report
Copy link

Link copied!

Hi all,

finally i got this works..

"ClearCollect(colGridData, Filter(CMD_NA_Tracker,Or(Assign.Value="Not Assigned")))" didnt get any delegation warning..

thanks to help me to develop..

Was this reply helpful? Yes No