Doubt with in operator

(0) Share

Report

Posted on by Marianr99

Goodmorning,

Thank you in advance for the help

I'm working with a Gallery and I need multiple filters on it,

I managed to make everything without delegation warning but I have a doubt

This is the code:

Filter(Opened_Files; 
 Autore in Security.Title; 
 Or(IsBlank(CB_Sito.Selected); //handle no selected values to give back every item
 IsEmpty(CB_Sito.Selected);
 Sito=CB_Sito.Selected.Value);
 StartsWith(Nome;TI_SearchDoc.Text);
 Or(IsBlank(CB_Rep.Selected); //handle no selected values to give back every item
 IsEmpty(CB_Rep.Selected);
 Reparto=CB_Rep.Selected.Value)
 )

There is a delegation warning using the "in" operator in the second line

The question is:

If the table "Security.title" will never exceed the 500 items, will it be okay for the table "Opened_Files" if there will be over 2k items? I mean, which one has to be less then 500/2k items? The first? The second? Or both?

If both needs to be under the limit, is there any way to bypass it and make it to be without delegation warning?

Another quesiton is:

I need another field to check with the in with the same table,

Thank you again

-Marian

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Marianr99 ,

Although the App doesn't know how many records are expected, it was always assume the worst case.
Your "in" operator gets multiple result as outcome therefore, its understood that Records can exceed 2000 delegation Row Limit.
Well, If let's consider another point where your App is maxed out with other records summing to 2000 already. Now, your App has to get new records for the Table you want, here your App will struggle to fetch all records and might result in missing data.

There are few ways to ensure App runs smoothly in future by developing it early.
1 of the efficient way which I use is Pagination. Reference YouTube Link
This can handle large data easily.

But if you have handled things properly in App with increase filters then not to worry.

Hope this helps

Was this reply helpful? Yes No
Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If the Security.Title list will never have more than 500 records you can ignore the delegation warning. It only applies in this case to that list since that is where the 'in' operator is being used.

Was this reply helpful? Yes No
Marianr99 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the answer, so if the Opened_Files doc library has more then 2k items there is no problem? Sorry if I ask it again, this is really important for me

Was this reply helpful? Yes No
Marianr99 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the quick answer

Was this reply helpful? Yes No
Verified answer

Pstork1 69,547 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

That shouldn't be a problem because you are using a single value from the doc library to see if it is "in" the other list. Its the target list that has to be below the data row limit not the library in this case.

Was this reply helpful? Yes No