web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation in Filter f...

Power Apps

Answered

Delegation in Filter function not working

(0) Share

Report

Report

Posted on by romankorchak2

125

Hi All

I have a SharePoint list with about 2500 items, which I need to get into my PowerApp.

So I made 2 collections :

ClearCollect(CDDIs1,Filter(SPList,ID < 1900) );
ClearCollect(CDDIs2,Filter(SPList,ID > 1899) );
ClearCollect(C_DDIs, CDDIs1,CDDIs2)

But it still shows Total of 2000 items in C_DDIs.

Unless I got it wrong, those 2 Filter functions should get all the items from the SP List?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

PTBBSolutions 691 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @romankorchak2 ,

The SP ID column is delegable only with = operator.

Please check this thread - I think it will show you a nice workaround.
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@romankorchak2 It will not work with the default SP List ID Column. But if you create your own ID column of type Number, your formula will work as seen in my example below.
romankorchak2 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your replies.
But what if I already have list with 5000 items, I dont think I can just add column with autoincrement IDs, and I cannot create a calculated column that would use value from current ID column?
Thanks
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@romankorchak2 You can use the existing ID column to create a new ID column,

UpdateIf(yourSPList, true, {newIDColumn:ID})
romankorchak2 125 on at

Like
a
(0)

Report
Copy link

Link copied!

That will do for existing items, but what about all items?

Join the conversation