web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Make a function delegable

Power Apps

Answered

Make a function delegable

(0) Share

Report

Report

Posted on by pcalzadovf

Hi, can anyone help me? I need to make the following statement delegable, because my Sharepoint list reached +2k registers:

Filter(
[@BILLING_FORECASTING],
CIF= First([@PowerBIIntegration].Data).CIF,
MONTH in Distinct([@PowerBIIntegration].Data, MONTH)
)

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @pcalzadovf ,

You can first use the delegable functions to save data to the collection in batches (it must be less than 2000 each time, because the collect function is not delegable). For example,

ClearCollect(Collection1,Filter(Table1,NumberCoulumn<1000)); Collect(Collection1,Filter(Table1,NumberCoulumn<2000 && NumberCoulumn>1000)); Collect(Collection1,Filter(Table1,NumberCoulumn<3000 && NumberCoulumn>2000));

Then you could use the formula to filter the collection:

Filter( Collection1, CIF= First([@PowerBIIntegration].Data).CIF, MONTH in Distinct([@PowerBIIntegration].Data, MONTH) )

Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation