You’re offline. This is a read only version of the page.
2
Hi everyone
I created a MS List using Excel as datasource. There is a column called "IDPart" as numeric. The IDPart is an ID for each row. I indexed the column IDPart. When I use Power Apps and try to collect more than 2000 items it doesnt work, even if I tried to get the first 200 items.
I use
ClearCollect(Data, Filter(MSList, IDPart < 200))
It shows 2000 items, when I use
ClearCollect(Data, Filter(MSList, IDPart < 2000),
Filter(MSList, IDPart >=2000 && IDPart < 4000)
Hi @LuidDatide ,
Could you please explain the situation more specifically? What's the data row limit setting in App studio? Please make sure it's set to 2000.
Besides, to collect items from Excel table into a collection, please use below method:
Share
Report
All responses (
Answers (
Concurrent(
ClearCollect(Data1,Filter(MSList, IDPart < 2000)),
ClearCollect(Data2,Filter(MSList, IDPart >=2000 && IDPart < 4000))
);
ClearCollect(Data, Data1, Data2)
Best regards,
