Combining 4 collection into one

[Cobergher]

Hi all,

I have a problem i can't seem to figure out.

I have a Excel datasource (i know, not the best source, but for now i have to deal with that)

The datasource has a table with 6500 rows, i know Powerapps has an issue with 2000+records.

I decided to split the original table, in Excel, into 4 smaller ones with<2000 rows. (columns are identical)

I then made an Onstart formula which loads the content of the 4 excel tables (Table_T1 to T4) into 4 collections (Collection A to D).

I then want to combine the 4 collections into one large collection.

However, that doesn't work, i can only combine 2 collection into a new one. (so Collection A & B into AB and C&d into CD)

Below is the Onstart code:

ClearCollect(CollectionA,Tabel_T1);
ClearCollect(CollectionB,Tabel_T2);
ClearCollect(CollectionC,Tabel_T3);
ClearCollect(CollectionD,Tabel_T4);

ClearCollect(Collection_AB, CollectionA, CollectionB);
ClearCollect(Collection_CD, CollectionC, CollectionD)

To test it i made 7 temp Galleries, and made the initial tables in excel only 10 rows long. The numbers correspondent with the column "ID"of the tables.

How can i combine all the collections into one large one ? Where do i go wrong.

[poweractivate]

@Cobergher 

Try this

Clear(Collection_All);
Collect(Collection_All,Tabel_T1,Tabel_T2,Tabel_T3,Tabel_T4)

or

ClearCollect(Collection_All,Tabel_T1,Tabel_T2,Tabel_T3,Tabel_T4)

See if it works.

[poweractivate]

@Cobergher 

I made a test, and it worked for me, even if the 4 Collections were different lengths, I got 1 big Collection with all the values there, see example below:

See if it helps @Cobergher 

[Cobergher]

Just tried, it doesn't work.

Well, both formula's work as long as i only use 2 collections:

Clear(Collection_All);
Collect(Collection_All,Tabel_T1,Tabel_T2)

Or

ClearCollect(Collection_All,Tabel_T1,Tabel_T2)

As soon as i try to add a 3th or 4th collection the formula doesn't work.

[poweractivate]

@Cobergher 

How many records are in Tabel_T1, Tabel_T2, Tabel_T3, and Tabel_T4?

[Cobergher]

For the simple test there are now only 10 records in each table

[poweractivate]

@Cobergher 

1. Check the delegation limit, and raise to as high as possible e.g. 2000.

2. The ClearCollect / Collect directly on the data source itself will only return as much as the delegation limit. So all Collections have an invisible delegation warning that shows no yellow triangle. You could load the Tables into Collections first, then you won't have the limit, since the limit might not apply to operations on Collections themselves, just on the Collect / ClearCollect when it is being created from a data source such as a table. So like this:

ClearCollect(Collection_AB_Temp,Tabel_T1,Tabel_T2);
ClearCollect(Collection_CD_Temp,Tabel_T3,Tabel_T4);
ClearCollect(Collection_All,Collection_AB,Collection_CD);
Clear(Collection_AB_Temp);
Clear(Collection_CD_Temp);

See if it helps @Cobergher 

[Cobergher]

I tried to, but i can't even populate a collection A with this formula:

ClearCollect(CollectionA,1,2,3,4,5)

[poweractivate]

@Cobergher 

You should not have the issue with just 10 records in each table. You may have the issue though, if each table had, say, 1000 records or 2000 records each.

It's odd that you have the issue with just 10 records per table. However, in case it happens to help with the issue (and especially if in the app, you will have e.g. 1000 or 2000 per Table) - try the recommendations I gave, see if they help.

Keep in mind that if you plan to have a lot of Records in each table, you might have an issue if they have a lot of Records and you want them in a Collection, so you may need to use the recommendation I gave, and ensure each table has 2000 records or less, and that the data row limit is set to the max of 2000.

[poweractivate]

@Cobergher 

If you create a blank app, is the issue there?