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)

Sort by

fyamasaki 7 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Yes, I hope someone has a solution for this

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

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 155,623 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Hi Warren! Thank you it worked! 😀

Was this reply helpful? Yes No