I merged 3 large data collection into one final collection. I use this method because I have large data from multiple SP list to pull from and to store it in multiple collection first and to merge the collection into one final collection.
I have merge few collections collected from SharePoint but the final collection return empty rows instead (Image 1). I have to click a value column in the collection view in PowerApps tab to expand collection rows (Image 2 & 3). The 3 collections before merging all returned correct collection with data inside it. Only the final one after merging return empty rows. Refer image below:
Final collection:
Image 1
After clicking value column in PowerApps collection view
Image 2
The collection in a value column. I have to click the value column to expand the data in the final collection. It seems like the data is stored in the value column instead of the final collection. This never happen before.
Image 3
Anyone know why this is happening to the collection?
This is the sample of my code for the collection.
Collect(
LargeListSP,
Set(
firstRecordMid,
First(SP_Midnight)
);
Set(
lastRecordMid,
First(
SortByColumns(
SP_Midnight,
"ID",
SortOrder.Descending
)
)
);
Set(
iterationsNoMid,
RoundUp(
(lastRecordMid.ID - firstRecordMid.ID) / 2000,
0
)
);
Collect(
iterationsMid,
Sequence(
iterationsNoMid,
0
)
);
ForAll(
iterationsMid,
With(
{
prevThresholdmid: Value(Value) * 2000,
nextThresholdmid: (Value(Value) + 1) * 2000
},
If(
lastRecordMid.ID > Value,
Collect(
LargeListSP1,
Filter(
SP_Midnight,
ID_Digit > prevThresholdmid && ID_Digit <= nextThresholdmid && DateDesignation >= DateFromGal.SelectedDate && DateDesignation <= DateToGal.SelectedDate
)
)
)
)
),
Set(
firstRecordAM,
First(SP_AM)
);
Set(
lastRecordAM,
First(
SortByColumns(
SP_AM,
"ID",
SortOrder.Descending
)
)
);
Set(
iterationsNoAM,
RoundUp(
(lastRecordAM.ID - firstRecordAM.ID) / 2000,
0
)
);
Collect(
iterationsAM,
Sequence(
iterationsNoAM,
0
)
);
ForAll(
iterationsAM,
With(
{
prevThresholdAM: Value(Value) * 2000,
nextThresholdAM: (Value(Value) + 1) * 2000
},
If(
lastRecordAM.ID > Value,
Collect(
LargeListSP2,
Filter(
SP_AM,
ID_Digit > prevThresholdAM && ID_Digit <= nextThresholdAM && DateDesignation >= DateFromGal.SelectedDate && DateDesignation <= DateToGal.SelectedDate
)
)
)
)
),
Set(
firstRecordPM,
First(SP_PM)
);
Set(
lastRecordPM,
First(
SortByColumns(
SP_PM,
"ID",
SortOrder.Descending
)
)
);
Set(
iterationsNoPM,
RoundUp(
(lastRecordPM.ID - firstRecordPM.ID) / 2000,
0
)
);
Collect(
iterationsPM,
Sequence(
iterationsNoPM,
0
)
);
ForAll(
iterationsPM,
With(
{
prevThresholdPM: Value(Value) * 2000,
nextThresholdPM: (Value(Value) + 1) * 2000
},
If(
lastRecordPM.ID > Value,
Collect(
LargeListSP3,
Filter(
SP_PM,
ID_Digit > prevThresholdPM && ID_Digit <= nextThresholdPM && DateDesignation >= DateFromGal.SelectedDate && DateDesignation <= DateToGal.SelectedDate
)
)
)
)
)
)
