web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power Apps ClearCollec...

Power Apps

Unanswered

Power Apps ClearCollection not working

(0) Share

Report

Report

Posted on by LuidDatide

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)

Categories:

Governance & administering

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation