Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Collection not returing results in Combobox

(0) ShareShare
ReportReport
Posted on by 252

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?

  • Ethan_009 Profile Picture
    Ethan_009 4,836 on at
    Re: Collection not returing results in Combobox

    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

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Collection not returing results in Combobox

    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

    Skybluekid_0-1688124029337.png

    and I am using the colPN in the Combo box

  • Ethan_009 Profile Picture
    Ethan_009 4,836 on at
    Re: Collection not returing results in Combobox

    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?

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard