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

[OCJ]

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.

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!

[EddieE · Accepted solution]

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

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.