Bibhash Jha

Bibhash Jha

  • 1.5k
  • 174
  • 14.2k

How to apply filter more than 2000 item in PowerApps

Jul 30 2019 6:09 AM
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 

Answers (1)