Combining of collections not working properly

[zuurg]

I'm trying to resolve a delegation issue with a large SharePoint list and found an example on here to merge multiple collections into 1 larger one.

I added a calculated column to my list and set it to the [ID] which duplicated the ID into a new column.  I got the same result doing that as I do without the use of the calculated column and simply referring to Value(ID) for the filtering.

Here's my code:

Concurrent(
    ClearCollect(col1,Filter('Tracking', Value(ID) > 1)),
    ClearCollect(col2,Filter('Tracking', Value(ID) > 2000)),
    ClearCollect(col3,Filter('Tracking', Value(ID) > 4000)),
    ClearCollect(col4,Filter('Tracking', Value(ID) > 6000))
);
ClearCollect(colCombined,col1,col2,col3,col4)

Here's what it produces:

As you can see, it loaded 2000 records into col1, only 207 records into col2, and nothing into cols 3 & 4.  The Tracking list currently has 7973 records in it, so it should have filled all 4 collections.  

The combining of the collections into colCombined was successful.

The code is being run in the App OnStart.  I've also tried it in the Screen's OnVisible and in a button.  I've also tried running them as individual statements instead of Concurrent, same result.

Can anyone shed some light on why col2 is only working partially and 3 & 4 aren't working at all?  As I've said, I got the same result when filtering for the Value of the calculated ID column.

[BCLS776]

Try this:

Concurrent(
    ClearCollect(col1,Filter('Tracking', Value(ID) > 1, Value(ID) <= 2000)),
    ClearCollect(col2,Filter('Tracking', Value(ID) > 2000, Value(ID) <= 4000)),
    ClearCollect(col3,Filter('Tracking', Value(ID) > 4000, Value(ID) <= 6000)),
    ClearCollect(col4,Filter('Tracking', Value(ID) > 6000, Value(ID) <= 8000))
);
ClearCollect(colCombined,col1,col2,col3,col4)

This makes your Filter() statements bring in a maximum of 2000 records each

Hope that helps,

Bryan

[zuurg]

Almost the same issue.

col1: 1793 rows

col2: 207 rows

col3: 0 rows

col4: 0 rows

colCombined: 2000 rows

[BCLS776]

OK, next remove them from the Concurrent() statement to ensure the service is treating them as 4 independent queries.

Bryan

[zuurg]

Same result as the previous attempt.  colCombined is a total of 2000 rows, col1: 1793, col2: 207

[BCLS776]

Oh, are you querying against your new calculated column or the original ID column? You should be querying against the calculated column.

Bryan

[zuurg]

I just recreated the calculated column and changed it to refer to Value(RowIndex).  Same result: 1793 in col1, 207 in col2, 2000 combined, blank col 3 & col4

[BCLS776]

Can you share the latest version of your code, please?

Bryan

[zuurg]

// Concurrent(
    ClearCollect(col1,Filter('Tracking', Value(RowIndex) > 1, Value(RowIndex) <= 2000));
    ClearCollect(col2,Filter('Tracking', Value(RowIndex) > 2000, Value(RowIndex) <= 4000));
    ClearCollect(col3,Filter('Tracking', Value(RowIndex) > 4000, Value(RowIndex) <= 6000));
    ClearCollect(col4,Filter('Tracking', Value(RowIndex) > 6000, Value(RowIndex) <= 8000));
// );
ClearCollect(colCombined,col1,col2,col3,col4)

[BCLS776]

Are there any delegation warnings on the code as you have it right now?

Bryan