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
what changes are required here to get the items in my gallery
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
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).
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.