Power Apps ClearCollection not working

Like (0) Share

Report

Posted on 1 May 2024 01:58:08 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

I have the same question (0)

All responses (1)

Answers (0)

v-jefferni on 02 May 2024 at 03:11:34

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,

Was this reply helpful? Yes No