Delegation Warning in startswith function - Previous its working

(1) Share

Report

Posted on by Jawaharprem

286

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)

Sort by

Suggested answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(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,992 Super User 2025 Season 1 on at

Like
a
(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 286 on at

Like
a
(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 286 on at

Like
a
(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 286 on at

Like
a
(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