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

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

PTBBSolutions 691 on at

Like (1)

Report

Hi @romankorchak2 ,

The SP ID column is delegable only with = operator.

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

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
romankorchak2 125 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@romankorchak2 You can use the existing ID column to create a new ID column,

UpdateIf(yourSPList, true, {newIDColumn:ID})

Was this reply helpful? Yes No
romankorchak2 125 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation