Unanswered

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

(0) Share

Report

Posted on by PowerAppBuilder24

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (1)

Report
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,

Was this reply helpful? Yes No
PowerAppBuilder24 20 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @PowerAppBuilder ,

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

Was this reply helpful? Yes No
PowerAppBuilder24 20 on at

Like (0)

Report
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?

Was this reply helpful? Yes No