Answered

IN() function impacting the app performance

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello

I am improving an App for field inspections that contains a Gallery with Filter functions and an IN function, here is the Items commend:

Filter(

Filter('Neptune - Bulk Material handling',
('Asset Name' = dd_Nepassets.Selected.Result) && (DropdownBlock_3.Selected.Result = 'Block Name')
),
TextSearch_3.Text in Title || TextSearch_3.Text in 'Location Detail'
)

My objective is to highlight the last submitted record on the Gallery using a variable record created with LastSubmit function. My conclusion following long investigation is that the IN function is preventing from achieving my goal, looks like the new/edited records are excluded from the query so the default have no record to highlight.

Any suggestions on how to deal with this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

It depends on the data source and delegation. For example, SharePoint does not delegate the in operator. If you replace it with StartsWith(), the formula will execute faster and work with large datasets.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp , Thanks for the quick reply.
It is relatively small SP list source. the dropdowns filters reduce it to less than 50 items.
I want to avoid using the StartWith() - it may be more disadvantage for this scenario.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, Agree with @Drrickryp about the delegation.

Have you considered that the new/edited records are not showing in your filter because you have not used Refresh(DataSourceName) ? I would put that on the onVisible of that screen where you are filtering or on the actionable property of whatever is doing the new/edit functionality.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @iAm_ManCat , It didn't help.
I probably will apply additional dropdowns to marrow the search.

Thanks for the assistance

Was this reply helpful? Yes No