Unanswered

Delegation Issues

(0) Share

Report

Posted on by Community Power Pla...

I have a sharepoint list with over 2000 items, I have a gallery with all the items in it with this in as the items:

SortByColumns(Search([@masterList], TextInput1.Text, "Point", "Equipment"), "Point", Ascending)

Not all the items show up in the gallery. Both sharepoint and galleries support delegation, so why does this happen?

If I use a collection of all the items of the gallery it works perfectly even though collection do not support delegation.

If someone could tell me why this is happening and also explain delegation, it would be much appreciated.

Thanks in advance

All responses (2)

Answers (0)

timl 35,193 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delegation Issues

@Anonymous

The short answer to this question is that with SharePoint, the Search function is not delegable. This is the reason why your gallery does not return all records that you expect.

The closest matching, delegable function that you can use is the StartsWith with function.

Delegation refers to the ability of Power Apps to translate a query (eg a search, or a filter operation) into one that the server (SharePoint in this case) can natively execute.

Search is not a delegable function - therefore, Power Apps retrieves a maximum of 2000 records onto the client and performs the search client side. This is the reason why you don't see all the records that you expect.

A collection is a local structure of data and is held completely locally. Therefore, delegation is a concept that does not apply to collections.
ragavanrajan 7,036 Most Valuable Professional on at

Like (0)

Report

Re: Delegation Issues

Hi @Anonymous ,

I am adding the official documentation from Microsoft for you to read. It contains good information on how delegation works

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview And the recent blog
https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/

There is a limit setting which you can increase file > app setting> advanced settings. Increase the limit here.
But the best way I can see is to use CDS aka DataVerse If you except large volumes.

PS: By the way you have posted in wrong forum. This forum is meant for Power Apps portal.

Hope it helps.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.