web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Clearcollect to avoid ...

Power Apps

Answered

Clearcollect to avoid Limit 2000

(0) Share

Report

Report

Posted on by Gochix

1,937 Moderator

Good morning,

this might be answered million times but i did search and couldn't find answer i need..

I have a big file which i need to use for a search function.

So i was looking around how to avoid 2000 data row limit and find the solution to use clearcollect function.

But then i came to a problem that i can't select ID in the actual Table.

Example attached.

Tried to use code :

ClearCollect(CollectNew,Filter(Table1,ID <= 2000))

But showing up that there is an error within ID

Original post where formula taken from :

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-i-manage-to-filter-more-than-2000-records/td-p/264784

If somebody can tell me why i can't use ID please let me know.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

One of our community member's blogs addresses the restrictions of querying on the ID field - only the '=' operator is allowed. Creating a second, "shadow" ID field might be the solution you need.

Bryan

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gochix ,

Please try to use flow to avoid the delegation problem.

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation