Hi
I am using the below to return a collection
Concurrent(
ClearCollect(
colPNChunk1,
Sort('Part List', Title, SortOrder.Ascending)
),
ClearCollect(
colPNChunk2,
Sort('Part List', Title, SortOrder.Descending)
)
);
ClearCollect(
colPN,
{Result: "All"},
colPNChunk1,
Filter(colPNChunk2, Not(ID in colPNChunk1.Title))
);
Clear(colPNChunk1);
Clear(colPNChunk2)
but the result are not showing in the combo box. Any ideas?
Hi @Skybluekid ,
That's because of the formula you added.
Then you performed 'Clear(colPNChunk1); Clear(colPNChunk2);' which cleared both collections to 0.
If you need to validate if your formula is correctly filtering records as per your conditions.
Add a Datatable(preview) control in the app. Then add formula of your Filter only and test the results.
Modify accordingly until you get and then replace in your main code.
Note: Don't clear your collections as you will need them to test your results.
Hope this helps
Hi @Ethan_R
When I look in the Collections it does show 0 records in Chunk 1 and Chuck 2, but in colPN it shows 2810 records
and I am using the colPN in the Combo box
Hi @Skybluekid ,
I think you are capturing same items in Chunk 1 and Chunk 2.
Then you are creating collection where Title in Chunk 1 not present in Chunk 2.
This will always return 0 records, right?