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).
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
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.