Why I can't create a Combo-Dropdown with a Choice Column?

[PowerAppBuilder]

Hello, 

I need some Help from the Experts... In my PowerAPP I created a Gallery. In where I placed some Fields which I want to Filter.

In this specific Case the Data from the Choice-Column is displayed in this Way: 

Concat(ThisItem.'ColumnName'.Value;Concatenate(Text(Value);","))

This results in this : Value1, Value2, .... Everything is working as expected... 

But for some Reason I cannot get each Choice as one Entry inside a Multi-Select-Dropdown and after the Dropdown I want to Filter the Gallery based on that Dropdown. But for the First I am happy if my Dropdown displays my Data Correctly. 

Thank you in Advance.

[SanmeshG]

Hi @PowerAppBuilder  ,

If the column is a choice column , then you can directly use this formula , in the items property of the combobox.

Choices([@SPList].ColumnName)

In the above expression if you want to split your choices for eg, if your choice for ThisItem.Column.Value is Choice 1, Choice 2 ,  Choice 3 and you want to split them based on ,(comma) , then you can use the below formula in the items property of your combo box(Which I am assuming is in your gallery).

ForAll(
    Split(
        ThisItem.ColumnName.Value,
        ","
    ),
    ThisRecord
)

If this helps , please give this a thumbs up . If this solves your issue please mark this as a solution.

Thanks,

[PowerAppBuilder]

Hi @SanmeshG ... 

Thank you for trying to help me. I really appreaciate it. Sadly your formula doesn't work properly. My Dropdown is not inside the Gallery. 

I have two Containers: 

- Left 

- Right 

In the Right one is the Gallery and in the Left one are my Dropdowns. I replaced the ThisItem to my Name of my Table but still it wont work. Which Information you need to help me? 

[SanmeshG]

Hi @PowerAppBuilder  ,

If you could add details with screenshot I can check it , Also the column type and values

[PowerAppBuilder]

Hello @SanmeshG , 

I checked the Data Format again and I saw that the Data is not in the CSV-Format. If I export the MS-List (where the Data is stored) looks like this: 

The Strange thing is that this Formula displays is almost in an CSV Format: 

Concat(ThisItem.'ColumnName'.Value;Concatenate(Text(Value);","))

Output of this Formula looks inside the Gallery like this: Value1,Value2,

I want a multiple Choice-Dropdown based on a Multiple-Input-Dropdown.... The Choices are defined inside in MS-List

The Data comes via an different PowerApp which is linked to that List... Did you get my Point?