Dear All,
In filtering (a large amount of) data-rows out of a (large) SharePoint list, I'm successfully avoiding delegation errors when using "normal" data rows, however not on the LookUp colum.
I'm combining two large data sets (20.000 rows each) for filtering, thus appended the row needed from one to the other by means of a LookUp column, and refer to it in the filter. The delegation error then occurs, and also prohibits all desired rows to come out of the filter (probably the 2000 entry limit). Is there a work-around for this?
Example code:
Filter(
PN_DIF_Status,
Status.Value = "Approved",
DIF_x003a_DepartmentCopy.Value = "Avionics"
)
Where the Status.Value = "Approved" does not give a delegation error, since the status column was already present in "PN_DIF_STATUS". The DIF_x003a_DepartmentCopy column is the LookUp column as used from another list. This one gives the delegation error and prohibits the correct use of the program.
Kind regards,
Sjoerd
