I'm facing an issue while trying to create collections from a list comprising approximately 9500 items (ID 11,000-20,000). My aim is to create a collection at the app OnStart I'm using the following process to create different collections and then consolidate them into one:
Concurrent(
ClearCollect(
colNotesA,
Filter(
'Social Services Notes',
ID < 13000
)
),
ClearCollect(
colNotesB,
Filter(
'Social Services Notes',
ID >= 13000 And ID < 15000
)
),
ClearCollect(
colNotesC,
Filter(
'Social Services Notes',
ID >= 15000 And ID < 17000
)
),
ClearCollect(
colNotesD,
Filter(
'Social Services Notes',
ID >= 17000 And ID < 19000
)
),
ClearCollect(
colNotesE,
Filter(
'Social Services Notes',
ID >= 19000 And ID < 21000
)
)
);
ClearCollect(
colSocialServicesNotes,
colNotesA, colNotesB, colNotesC, colNotesD, colNotesE
);
However, I've noticed that the number of items returned in each collection doesn't add up to the total of over 9500 items that are supposed to be in my list.
Would appreciate any insights or assistance on why this might be happening or if there's a more effective way to create these collections. Thank you!

Report
All responses (
Answers (