cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OCJ
New Member

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
EddieE
Super User
Super User

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

 

 

View solution in original post

2 REPLIES 2
EddieE
Super User
Super User

@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
New Member

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,684)