Can i make delegable

(0) Share

Report

Posted on by PowerApps11

521

I have this formula is there a way to make it delegable?

With(
 {
 colAllItems: Filter(TasksLB, Status.Value = "Closed") 
 },
 ForAll(
 Sequence(CountRows(colAllItems)),
 Patch(
 Last(
 FirstN(
 colAllItems,
 Value
 )
 ),
 {rowNum: Value}
 )
 )
)

How can I change my approach or rewrite these so that It can be delegate?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerApps11 ,

That bottom bit looks familiar . . . it should be used for numbering rows, however when used, the With() statement is limited in output to your Delegation limit. Your filter at the top however is Delegable within the above
PowerApps11 521 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
You right
is there an alternative for numbering rows without using With ?
thanks
Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerApps11 ,

With() is not the only Delegation issue - CountRows() is not Delegable nor is FirstN() , so even if you did the filter twice not using With(), it is still not Delegable.

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