Adding a Collection to Combobox for searching

(0) Share

Report

Posted on by Skybluekid

262

Hi All,

I have create a collection which is capturing a list distinct list of Descriptions(original list is over 2000 records and includes lots of duplicates). I am using the below

ClearCollect(Desc,{Result: "All"},Distinct('Part List',Description)). I have placed this in a Combobox, so I can search for a record.

When I play the app, all I have in the list is the word "All" and lots of blank lines. Any ideas as to where I am going wrong?

Thanks in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Skybluekid ,

Please try:

ClearCollect(Desc,{Value: "All"},Distinct('Part List',Description))

Best Regards,

Bof

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft

Thank you for the quick reply. I have changed it to Value in the collection. In the Combobox it is showing an error.

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft
No worries it is now working. Thank you

Was this reply helpful? Yes No