How to apply filter more than 2000 item in PowerApps

I have a SharePoint Online list the has contained 5000 items. I have created a PowerApp with the data source SharePoint list. I want to filter on 5000 items but PowerApp gets only 2000 item.

I tried

Concurrent(

ClearCollect(CollectionA,Filter(NameofTable,ID<2000)),

ClearCollect(CollectionB,Filter(NameofTable,ID >=2000 And ID<4000)),

ClearCollect(CollectionC,Filter(NameofTable,ID >=4000 And ID<6000)),

ClearCollect(CollectionD,Filter(NameofTable,ID >=6000 And ID<8000)),

ClearCollect(CollectionE,Filter(NameofTable,ID >=8000 And ID<10000)),

ClearCollect(CollectionF,Filter(NameofTable,ID >=10000 And ID<12000)),

ClearCollect(CollectionG,Filter(NameofTable,ID >=12000 And ID<14000)),

ClearCollect(CollectionH,Filter(NameofTable,ID >=14000 And ID<16000))

)

but this does not work. Pls help me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Aakash Maurya7y ago
The thing that you have done should work.

Because that is the way to overcome the limit..

But you have to combine that all collections together using

ClearCollect(NewBigCollectionName,CollectionA,CollectionB,CollectionC,CollectionD,CollectionE,CollectionF,CollectionG,CollectionH, ....................)

Let me know what error you get.

NOTE: NewBigCollectionName will be new collection name that will contain all items