
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!
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