Delegation Issue on Formula

(0) Share

Report

Posted on by asuhaimi

Hello..

Can someone help me how to solve delegation issue on my formula below.

Sort(
Filter(
'Greyhound 2022 - ACTIVITY',
(StartsWith(
'WORK ITEMS',
txtPICWorkItemsOverallActivity.Text
) || StartsWith(
PIC.DisplayName,
txtPICWorkItemsOverallActivity.Text
)) && (STATUS.Value = drpSTATUSOverallActivity.Selected.Value || drpSTATUSOverallActivity.Selected.Value = Blank()) && (SECTION.Value = drpSECTIONOverallActivity.Selected.Value || drpSECTIONOverallActivity.Selected.Value = Blank())
),
Modified,
Descending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@asuhaimi ,

What is showing as a Delegation issue ? All of that looks fine to me

Sort( Filter( 'Greyhound 2022 - ACTIVITY', ( StartsWith( 'WORK ITEMS', txtPICWorkItemsOverallActivity.Text ) || StartsWith( PIC.DisplayName, txtPICWorkItemsOverallActivity.Text ) ) && ( STATUS.Value = drpSTATUSOverallActivity.Selected.Value || drpSTATUSOverallActivity.Selected.Value = Blank() ) && ( SECTION.Value = drpSECTIONOverallActivity.Selected.Value || drpSECTIONOverallActivity.Selected.Value = Blank() ) ), Modified, Descending )

Was this reply helpful? Yes No
asuhaimi 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Sorry, my mistake.. the issue on countrows

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @asuhaimi ,

Correct - CountRows is not Delegable - it will however count correctly up to your Delegation limit - if you want to get rid of the warning (and that is all this does - still only works up to Delegation limit)

With( {wList:'Greyhound 2022 - ACTIVITY'}, CountRows(wList) )

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