Add collection and Choice to a dropdown control

[Ga_2004]

Hello , 

I have a dropdown list which is from a choice from a database . 

I want to add an item additional to the dropdown 

Eg Choice ( honda, toyota, Hyundai ) 

I want to all "All " to the top of the list.  So users can have option to select all or any of the can filter. 

I tried using a collection with ALL and combine with the choice on the items for Dropdown does not work as one is string and another choice list .. 

ClearCollect( colCategory,{Value: "All"});Collect(colcategory, Choices(DB_Tools_Registers.MES_Content_type));

How can I add "ALL" to the dropdown . ?

thanks

regards

ga

[Pstork1]

Your on the right track, but you need to make sure that the record for "All" matches the fields that are available in the Choice collection.  For a simple dropdown the following will work.

ClearCollect(mytest,{Value: "ALL"},Choices(Test_New.status))

But I suspect your Choices() result has different field names.  Try a ClearCollect first with just Choices(datacolumn).  Then look at the collection produced and add a record for "All" that matches the field names in your Choices() list.

[Bilakanti]

@Pstork1 ,

Its not working in my case . Screenshot Below.

[Pstork1]

What does the Collection look like for just the Choices('Category (Accounts)')?  You have to do that one by itself first to see what fieldnames are being used.  It isn't always Value.

[Bilakanti]

@Pstork1 ,

It has only Value column. Screenshot below.

[Pstork1]

Based on that screen shot it has Value and two other properties that are throwing errors.  That would be the root of the problem.  If you can't add the Choices to a Collection then you can't add an "All" entry to the result.  Work on getting the Choices column in some form to a collection. Once that is working you can add the "All".

[Ga_2004]

Hi @Pstork1 

I am getting this error while I try this 

when I try to clearcollect the choices i get a similar error 

regards, 

ga

[Pstork1]

Your original question said, "I have a dropdown list which is from a choice from a database".  But based on the error message when you tried to do the ClearCollect on just the Choices() this isn't a dropdown based on a database.  This is an Option Set.  Option sets are different than regular dropdowns and are specific to CDS.  There is no way that I know of to add a custom choice to an Option set at runtime.  Its not the same as adding one to a regular dropdown.  That's why this isn't working for you.  I don't know of any supported workaround.

Take a look at the following article about working with Option Sets.

Working with CDS Entity Option Set field - Power Platform Community (microsoft.com)

[Ga_2004]

Hi @Pstork1 

thanks for the response, 

yes it is a option set from the DB as below i have added this to a Dropdown box. 

Where DB_tools_register is a Database created in Teams and MES_content_type is the Column which is a choice list as below.. 

So in this case is there any other workaround to add "All" or use another control to add these ? 

regards,

ga.

[Pstork1 · Accepted solution]

There is no workaround to do it at run time.  Your only choice is to add a value to the Option Set itself by editing the column in the database.