web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Non-Delegable gallery ...

Power Apps

Answered

Non-Delegable gallery formula

(0) Share

Report

Report

Posted on by zayarminaye

61

Dears,

I am having below formula which is non-delegable formula. How do i make it delegable formula in order to avoid unnecessary issues in the future? Your support is highly appreciated.

If(LookUp('SP1', RequestID = ThisItem.RequestID, Status.Value) = "In-Use" && CountRows(Filter('SP2', RequestID = ThisItem.RequestID)) < 2, true, false)

Best Regards,

Zayar

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

QuentinDURIEZ 577 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

I image that you have a delegation warning for the CountRows part of the formula, this formula is non-delegable with SharePoint.

So Instead of this, use a combination of Sum, ForAll and Filter :
LookUp('SP1', RequestID = ThisItem.RequestID, Status.Value) = "In-Use" && Sum(ForAll(Filter('SP2', RequestID = ThisItem.RequestID), 1), Value) < 2

(And you don't need a If statement since your formula will return a bool)

Regards,
zayarminaye 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, @QuentinDURIEZ . It worked perfectly. Appreciate your support.

Join the conversation