cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VivekKumar12
Frequent Visitor

StartsWith delegation warning in PowerApps

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. 

VivekKumar12_0-1617102807260.png

VivekKumar12_1-1617102822287.png

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

 

8 REPLIES 8
Drrickryp
Super User
Super User

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. 

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
Super User
Super User

@VivekKumar12 

Those are dropdowns for your choice columns

your code is not working

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

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

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

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).

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (5,563)