Power Platform Community Forum Thread Details

Hello together,

I am looking for a solution that makes it possible to manually add new choices to a multiple choice dropdown. In this column I want to save machine characteristics for every order. I need something like a "growing" dropdown, where i can re-use characteristics that are the same like in another order by selecting it and also add new characteristics that were not used in the past.

It should be possible to select two or more choices (that are already existing in my sharepoint list multiple choice column) AND add new choices. So for example one scenario could be that i want to patch into my multiple choice column in sharepoint list two existing choices from my dropdown and also two new choices that are not in my dropdown because they are "new".

Is there a way how i can face this problem?

Thanks in advance

Lukas

___________________

Categories:

Building Power Apps

Hello , I tried to explain the solution step by step. Feel free to ask if there is anything you don't understand.

In this step, I created a SharePoint list named TestListe_MEK2. I added columns named Titel (Text type), Titel_New (Text type), and ComboboxColumn (MultipleChoice type).
Within the PowerApps application, I created a Combobox control.
I set the properties of the Combobox control as follows:
- Items: Sort(ComboboxColumnUniqueValues; Value; SortOrder.Ascending)
To create the collection used in the Items property of the Combobox, we write the following formula in the AppOnStart property or the page’s OnVisible property:

ClearCollect(
AllValuesWithBlanks,
Ungroup(
ForAll(
TestListe_MEK2,
{ComboboxColumnValues: ComboboxColumn}
),
ComboboxColumnValues
)
);
ClearCollect(
ComboboxColumnUniqueValues,
Filter(
Distinct(
AllValuesWithBlanks,
Value
),
Not IsBlank(Value)
)
)
Summary of the steps so far:
- We created a collection for the Items property of a Combobox control. The elements of this collection consist of the options previously selected in the ComboboxColumn column in the SharePoint database.
In this step, we place a TextInput control on the screen. We will save the data entered into this control to the database along with the selected items in the Combobox control. (Note: We cannot directly show the value written here inside the Combobox.)

In this step, we add a Save button and write the following formula:

OnSelect:

Patch(
    TestListe_MEK2,
    Defaults(TestListe_MEK2),
    {
        Titel: "Title 11",
        Titel_New: "Titel 22",
        ComboboxColumn: Table(ComboBox1.SelectedItems,[TextInput1.Text])
    }
)