Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

App without delegation can't go past 2000th row in Sharepoint list

(1) ShareShare
ReportReport
Posted on by 22

Hello!

 

I have an application that was created avoiding Delegation issues (so no yellow triangles anywhere) but after my list grew past the 2000th line, it stopped reading further content from it. 

 

I have a Sort(Distinct(<SPOList>,<Column>),Result) as the Items property on a Dropdown but anything on "Column" after the 2000th line is not picked up by the Distinct function. As you see below, no delegation warning is indicated, so I assume the data source will delegate the request.

 

OCJ_0-1652215367089.png

I tried loading the list to a collection but again it only loads the first 2000 lines from it, so no luck in there as well. I also tried to load the collection with the distinct above, but it also loads only the different lines above the 2000th line. 

 

If I don't have delegation warning, shouldn't the SPO list be performing the distinct on the source before handing over the data to PowerApps?? Because to me, it seems that there's no difference on having a delegation issue or not in the app, it is behaving the same way regardless delegation issues... That more or less renders PowerApps useless for any usage when you have more than 2000 lines in a list...

 

Thanks in advance!

  • OCJ Profile Picture
    OCJ 22 on at
    Re: App without delegation can't go past 2000th row in Sharepoint list

    Thanks @EddieE 

    I've read through the Delegation Overview document before but they don't mention Distinct function in there at all. Looking the link you shared, for the Distinct function specifically, I see it mentions it is not possible to delegate.

  • Verified answer
    EddieE Profile Picture
    EddieE 4,641 on at
    Re: App without delegation can't go past 2000th row in Sharepoint list

    @OCJ 

    Distinct cannot be delegated and may only sometimes show a warning, MS Docs


    When used with a data source, this function can't be delegated. Only the first portion of the data source will be retrieved and then the function applied. The result may not represent the complete story. A warning may appear at authoring time to remind you of this limitation and to suggest switching to delegable alternatives where possible. For more information, see the delegation overview.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard