Collections maxes out at 2000 when populating with SharePoint list datasource

[ubikwitous]

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:

SortByColumns(
    Search('Events',
        TextSearchBox1.Text,
        "Location"
    ),
    "Title",
    If(
        SortDescending1,
        SortOrder.Descending,
        SortOrder.Ascending
    )
)

[ubikwitous]

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

[martinav]

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?

[ubikwitous]

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?

[martinav]

@ubikwitous ,

I updated my post after you posted your reply.  Please check the setting I mention and verify.