I have an app where on the OnView property for a screen, a collection is created from a SharePoint list datasource.
ClearCollect(CompletedRequestsCollection, CompletedRequests)
I then try to work around the delegation issue within a gallery by sorting/filtering the collection that is created from OnView. However, even though there is no filtering on this datasource and there is no indication of non-delegation, the collection that is created OnView always maxes out with the first 2000 items in the list. Is this expected? Are there any workarounds?
Solved! Go to Solution.
Thanks for the reply @martinav !
I still can't get it working. I've tried going back to the original, but still no luck. Is there a way to refresh the data set post updating? No matter what I do, it is only showing the older events and nothing newer, which leads me to believe it just isn't pulling them. Thanks!
For onVisible:
Concurrent(
ClearCollect(List1,Filter(SortByColumns('Events',"ID",Ascending),ID>0)),
ClearCollect(List2,Filter(SortByColumns('Events',"ID",Descending),ID>0))
);
ClearCollect(CollectionNew,List1,Filter(List2, Not(ID in List1.ID)));Clear(List1);Clear(List2)
On the BrowseGallery, I have:
Collect(CollectionNew, BrowseGallery1.AllItems)
And for Items:
Actually, in order to get the newer items, wouldn't I somehow need to just collect the start time descending from the top instead of using the ID. I don't actually need everything and I think the newest 2000 are probably current.
Still can't get it to work. No matter what I do, the screen doesn't refresh with different data.
Concurrent(
ClearCollect(CollectionNew,Filter(SortByColumns('Events',"Start_x0020_Time_x0020_Local",Descending))
Please post your entire statement. It looks like its truncated.
Also, I shouldnt assume... but did you change your app settings to increase the data row limit?
Sorry @martinav - that last statement was me just playing around trying to figure out if I could just grab the top 2000 most recent events by using the start date field.
I also tried just grabbing 4000 items without the time filter (posted here), but no matter what I put into onVisible, it doesn't really change anything that displays. Is it the Items messing it up?
I updated my post after you posted your reply. Please check the setting I mention and verify.
I have a post that shows how to load a static excel file of >42000 zip codes. Check it out here. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-u...
User | Count |
---|---|
261 | |
110 | |
97 | |
53 | |
39 |