web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Growing Multiplce Choi...
Power Apps
Suggested Answer

Growing Multiplce Choice Dropdown

(0) ShareShare
ReportReport
Posted on by 4
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:
I have the same question (0)
  • Suggested answer
    Mehmet_Powerapps Profile Picture
    26 on at

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

    1. 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).

    2. Within the PowerApps application, I created a Combobox control.

    3. I set the properties of the Combobox control as follows:

      • Items: Sort(ComboboxColumnUniqueValues; Value; SortOrder.Ascending)
    4. 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)
          )
      )
       

    5. 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.

    6. 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.)

    7. 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])
            }
        )
        
        
         
         

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 403

#2
WarrenBelz Profile Picture

WarrenBelz 338 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 320 Super User 2025 Season 2

Last 30 days Overall leaderboard