Add static value to a dynamic dropdown values

[PowerApps20201]

Hi All,

I want to add a static value in the dynamic dropdown list.

By using the following formula I am taking the distinct values in the dropdown box

Distinct(DeviceOrders, 'Product Status')

I want to add a static value i.e. "All" in the dynamic dropdown list. I try to used collection to add static value but it gives me an error.

Please help me...!

Thank you

[WarrenBelz · Accepted solution]

Hi @PowerApps20201 ,

You need a Collection

ClearCollect(
   colMyDD,
   {Result:"All"}
);
Collect(
   colMyDD,
   Distinct(
      DeviceOrders, 
      'Product Status'
   )
)

then the Items of the drop-down will be colMyDD (or whatever you want to call it)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[PowerApps20201]

Hi @WarrenBelz ,

Thank you for your response.

I tried to implement the solution given by you on "OnVisible" property of Screen as follows:

But got an error as below:

Thank you

[WarrenBelz]

Hi @PowerApps20201 ,

The syntax is correct providing your Distinct filter is - see test example below

What type of field is 'Product Status' ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[PowerApps20201]

Hi @WarrenBelz ,

I am using 'Product Status'  as "Option Set" DataType.

[WarrenBelz]

Hi @PowerApps20201 ,

Try this

ClearCollect(
   colMyDD,
   {Result:"All"}
);
Collect(
   colMyDD,
   Distinct(
      AddColumns(
         DeviceOrders,
         "ProdStatus",
         'Product Status'.Value
      ),		 
      ProdStatus
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[PowerApps20201]

Hi @WarrenBelz,

I tried to implement the solution given by you as follows:

But got an error

How can I resolve the above error?

Thank you

[WarrenBelz]

@PowerApps20201 ,

Re-posting the same question after 40 minutes may not be helpful - I am not constantly online and anyone looking at this needs to know that you are dealing with a CDS Option Set.

I am a SharePoint user and tested this on a Choice field (similar structure) and it produced the desired result (hence I posted the suggestion).

Here is a good document on Option sets - you may find some assistance there.

[PowerApps20201]

Hi @WarrenBelz,

Thank you for your response.