web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / App without delegation...
Power Apps
Answered

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

(1) ShareShare
ReportReport
Posted on by 34

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!

Categories:
I have the same question (0)
  • Verified answer
    EddieE Profile Picture
    4,641 Moderator on at

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

     

     

  • OCJ Profile Picture
    34 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard