Another delegation issue

[hpc1]

I try to get all records of a certain date range from a SP list. The total of the records in this date range is around 3'000. The dates are all converted to numbers (Date2Num) but nevertheless I get a delegation warning and I don't get all the records with the following filter function:

ClearCollect(colNotenuebersicht;
Filter(Notenuebersicht;

Date2Num >= LookUp(Jahresplan;Title="Beginn Semester 1";Date2Num) ;

Date2Num <= LookUp(Jahresplan;Title="Ende Semester 1";Date2Num)))

What did I do wrong?

[Drrickryp · Accepted solution]

@hpc1 

If your list is between 2k and 4k you can create a collection and use it instead of your SPlist to use Search(), the in operator with a filter.  This formula will work for SP lists up to 4000, after that a different method will be needed.

Concurrent(
    ClearCollect(
         col1,
         Sort(SPlist, ID, Ascending)
     ),
     ClearCollect(
         col2,
         Sort(SPlist, ID, Descending)
     )
);
 ClearCollect(
     colAll,
     col1,
     Filter(col2, Not(ID in col1.ID))
 );
Clear(col1);
Clear(col2)

[hpc1]

Thank you very much. It worked!