Answered

Question In regard of Delegation + Performance need help

(1) Share

Report

Posted on by BrkProdig

Hi Guys,

I'm building a gallery that is being filtered by a combobox + a text box, the data comes from a Sharepoint list with around ~200 entries, the filter is currently working but it's giving a delegation warning and it's kinda laggy.

I've the print of the code that I'm using, can someone help me to build a more efficient code that doesnt run into delegation issues, and that the response is faster? It would be really appreciated!

Code:

Filter('Digital_Library_2.0';

(
IsEmpty(
localizar_catalog.SelectedItems.Result)

||
IsBlank(
localizar_catalog.SelectedItems.Result)

||

field_3 in localizar_catalog.SelectedItems.Result

)

&&
(
TextInput1_1.Text in Title
||
TextInput1_1.Text in field_1
||
TextInput1_1.Text in field_2
)

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

fyamasaki 7 on at

Like (1)

Report

I'm running into a similar issue, looking forward to knowing a workaround

Was this reply helpful? Yes No
BrkProdig 19 on at

Like (1)

Report

Yes, I hope someone has a solution for this

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

Hi, I would suggest posting this on the Power Apps/Canvas Apps forum:

Power Apps Community - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report

Hi @WarrenBelz

This thread is for you. Sorry, we don't have permission to move.

Please help.

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

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @BrkProdig ,

Firstly, the in filter is simply not Delegable in SharePoint and each one of your filter criteria contains it, so there is no opportunity to "pre-filter" to improve this. However, if your list numbers are always going to be under your (maximum 2,000) Delegation limit, this will "mask" the issue (you will not get a warning, but the limit is still there) and possibly run a bit faster

With( {wList: 'Digital_Library_2.0'}; Filter( wList; ( Len(localizar_catalog.Selected.Result) = 0 || field_3 in localizar_catalog.SelectedItems.Result ) && ( TextInput1_1.Text in Title || TextInput1_1.Text in field_1 || TextInput1_1.Text in field_2 ) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BrkProdig 19 on at

Like (0)

Report

Hi Warren! Thank you it worked! 😀

Was this reply helpful? Yes No