Unanswered

Delegation workaround

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I tried to import the data from my entity to a collection doing the folllowing:

ClearCollect(CurrentRelease;Filter('DLR Execution';DLR_ReleasesID.PrimaryId=Dropdown2.Selected.Value))

But I am still getting only 500 records.

How should I do to load more than 500 records from an entity to a colllection?

Thanks

Martín

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi mdegraf,

Please check this documentation about delegation for more details:
https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

This part could be a reference for you. It seems that since the filtering will be done locally, only the first 500 records of the million records will be scanned. If the desired record is record 501 or 500,001, it will not be considered or returned by Filter.

If convenience, please consider to create a request for extending delegation limit to more than 500 items at PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer @v-yamao-msft!

I read in the documentation that if i use CDS and Filter (with delegable functions) it can be delegated -> https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

My idea was to store it in a collection and work with it.

Is it not possible then? 😞

THanks

Martin

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

You could filter the data source then save it in a collection. But you might only get the first 500 records from the CDS entity.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Nagaviswanath 86 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yamao-msft

I am using a collection to store the data which is being filtered from >500 rows but still it applies Filter function on first 500 rows of Excel which makes my application useless with out this feature.

Do you know any workaround for this issue?

Kind regards

Was this reply helpful? Yes No