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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,230)