StartsWith delegation warning in PowerApps

[VivekKumar12]

I'm getting this delegation warning and that why I'm not able to fetch records more than 500 but I want to fetch the records more than 2000. 

I want to get more than 2000 records in my gallery but getting this delegation warning and unable to fetch it more than 500 items in gallery.

SortByColumns(Filter([@'Don''t Walk By'], StartsWith('Don''t Walk By Type'.Value, TextSearchBox1.Text) || StartsWith(Category.Value, TextSearchBox1.Text) || StartsWith(Site.Value, TextSearchBox1.Text)), "Created", If(SortDescending1, Ascending, Descending))

Don't Walk By Type : Choice
Category : Lookup
Site: Lookup

  what changes are required here to get the items in my gallery

[Drrickryp]

Hi @VivekKumar12 

Choice columns in SharePoint are not delegatable for a text search.  Either use a dropdown for these column types as below

SortByColumns(
              Filter([@'Don''t Walk By'],
                      'Don''t Walk By Type'.Value = ddType.Selected.Value|| 
                       Category.Value=ddCategory.Selected.Value || 
                       Site.Value=ddSite.Selected.Value),
            "Created", If(SortDescending1, Ascending, Descending)
)

  or change them in SharePoint to single line of text and control the input from the PowerApps side with a hard coded dropdown.  See https://powerusers.microsoft.com/t5/News-Announcements/The-Ten-Commandments-of-SharePoint-in-PowerAp... ... #1.

IMHO, I prefer the latter and never use complex column types in SharePoint. 

[VivekKumar12]

what is ddType, ddCatergory and ddSite, I applied your formula but it's not working. It's saying name is not valid the identifier is not recognised

[Drrickryp]

@VivekKumar12 

Those are dropdowns for your choice columns

[VivekKumar12]

your code is not working

[VivekKumar12]

Don't Walk By Type : Choice
Category : Lookup
Site: Lookup

[Joorge_c]

The problem is your sharepoint column types. Formulated, lookups or choices are limited. Make them text.

[VivekKumar12]

not allowed to change at SharePoint side, I need to fix this without changing at sharepoint side

[Joorge_c]

what you could try is collect your entire sharepoint data into 2-3 collections in the app on start, then merge the multiple ones into a single collection which will read your entire data.

See how you can partition to collect in badges which will make up your entire data (over 2k rows).