Unanswered

Delegation Warning when using Startswith.

(0) Share

Report

Posted on by JaboUchiha

Hello friends, hope you´re doing great.

Would you be so kind to help me on this? Currently I have a Power App that is pulling data from a SharePoint list, my SharePoint list has more than 2000 rows and beyond that line my App is not showing additional info, checking the details in the warning message I found that "Starts with" is not working with one of columns. This is my current formula:

Sort By Columns(Filter([@'Admin Task Tracker'], Starts With('BSO Partner Text', TextSearchBox1.Text)),"BSO_x0020_Partner_x0020_Text", If(SortDescending1, Sort Order.Descending, Sort Order.Ascending))

I was looking for a solution but I did not found it 😞

@gabibalaban

Regards.

Categories:

Building Power Apps

Startswith.png

I have the same question (0)

All responses (8)

Answers (1)

EddieE 4,641 Moderator on at

Like (0)

Report

@JaboUchiha

Try using Sort() instead of SortByColumns()

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JaboUchiha - I'm surprised that you're seeing this warning as StartsWith should be delegable. What's the data type of your 'BSO Partner Text' column?

Was this reply helpful? Yes No
JaboUchiha 8 on at

Like (0)

Report

It´s a calculated column, the original one is "Choice column" and this new one is pulling data from there and copying as "Single line of text". Both columns belongs to same SharePoint list.

Was this reply helpful? Yes No
JaboUchiha 8 on at

Like (0)

Report

Thanks for your help, I made this:
Sort(Filter([@'Admin Task Tracker'],StartsWith('BSO Partner Text', TextSearchBox1.Text)),"BSO_x0020_Partner_x0020_Text", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
But still showing the same warning massage about delegation 😞

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like (1)

Report

@JaboUchiha

StartsWith is only delegable on Text type and Complex type columns - not Calculated columns, ie

Link
https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @JaboUchiha

As @EddieE correctly says, calculated columns are not delegable. Therefore, the StartsWith forumula that you're using will not be delegable.

If you need a delegable search, the other options available is to do an exact match with Filter, or to create a Flow to copy the text into a non-calculated column (which would support StartsWith).

Was this reply helpful? Yes No
JaboUchiha 8 on at

Like (0)

Report

Thanks for your support guys, I used a drop down button instead of search box, that solved the issue.

Was this reply helpful? Yes No
Harsh440378 2 on at

Like (0)

Report

Hi I am facing same problem can you explain how you solved using drop down

Was this reply helpful? Yes No