Delegation Warning in startswith function - Previous its working

(1) Share

Report

Posted on by Jawaharprem

225

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:

General Questions

Using Apps Using Formulas

Dataflows

All responses (5)

Answers (0)

Jawaharprem 225 on at

Like (0)

Report

Delegation Warning in startswith function - Previous its working

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..
Jawaharprem 225 on at

Like (0)

Report

Delegation Warning in startswith function - Previous its working

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...
Jawaharprem 225 on at

Like (0)

Report

Delegation Warning in startswith function - Previous its working

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

SaiRT14 1,961 Super User 2025 Season 1 on at

Like (0)

Report
Delegation Warning in startswith function - Previous its working

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.
Suggested answer

mmbr1606 12,108 Super User 2025 Season 1 on at

Like (1)

Report
Delegation Warning in startswith function - Previous its working

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