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

All responses (6)

Answers (1)

BrkProdig 19 on at

Like (0)

Report

Re: Question In regard of Delegation + Performance need help

Hi Warren! Thank you it worked! 😀
Verified answer

WarrenBelz 147,809 Most Valuable Professional on at

Like (1)

Report
Re: Question In regard of Delegation + Performance need help

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
ragavanrajan 7,036 Most Valuable Professional on at

Like (1)

Report

Re: Question In regard of Delegation + Performance need help

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.
oliver.rodrigues 9,315 Most Valuable Professional on at

Like (1)

Report

Re: Question In regard of Delegation + Performance need help

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

Power Apps Community - Power Platform Community (microsoft.com)
BrkProdig 19 on at

Like (1)

Report

Re: Question In regard of Delegation + Performance need help

Yes, I hope someone has a solution for this
fyamasaki 7 on at

Like (1)

Report

Re: Question In regard of Delegation + Performance need help

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