Power Apps ClearCollection not working

(0) Share

Report

Posted on by LuidDatide

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)

Categories:

Environment

All responses (1)

Answers (0)

v-jefferni on at

Like (0)

Report
Re: Power Apps ClearCollection not working

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:

Concurrent( ClearCollect(Data1,Filter(MSList, IDPart < 2000)), ClearCollect(Data2,Filter(MSList, IDPart >=2000 && IDPart < 4000)) ); ClearCollect(Data, Data1, Data2)

Best regards,