Collection not returing results in Combobox

(0) Share

Report

Posted on by Skybluekid

262

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No