Skip to main content

Notifications

Community site session details

Community site session details

Session Id : SP1zuLNjm/YUt6FJkA1eDT
Power Apps - Building Power Apps
Answered

How to Add Other Choices in Dropdown List

Like (0) ShareShare
ReportReport
Posted on 26 Apr 2022 01:40:28 by

Hi, I have to create a dropdown list where the user able to add another choices in canvas app. Is there any code that I have to include?

  • MatthewEdwards Profile Picture
    14 on 19 Mar 2024 at 11:00:56
    Re: How to Add Other Choices in Dropdown List

    Hello,

     

    I have tried the code posted from the link you shared but its not working for me.

     

    I have a table called shoppings and a choice column called vegetables, i want the option to be able to add different vegetables to the choice from the drop down as per the blog post.

     

    Ungroup(
     Table(
     {DropdownOptions: Choices('Shoppings'.vegetables)},
     {DropdownOptions: ["Other"]}
     ),
     "DropdownOptions"
     )

     

     

    I get an error:

     

    Table doesnt contain any column of text type. 

  • mrwilliams Profile Picture
    50 on 25 Jan 2024 at 11:19:21
    Re: How to Add Other Choices in Dropdown List

    Following on from this discussion, can anyone help me with my problem? I have used this code and I want to add the option of "All Pupils" but it doesn't add it to the list...

     

    Ungroup(
     Table(
     {pupilOptions: ["All Pupils"]},
     {pupilOptions: Groups}
     ),
     "pupilOptions"
    )

     

    The result is this:

    Groups.png

    What am I missing?


    Thanks

  • khaledfawzy Profile Picture
    20 on 08 Feb 2023 at 07:10:03
    Re: How to Add Other Choices in Dropdown List

    Ungroup(
    Table(
    {DropdownOptions: Choices('incoming-list'.docsource)},
    {DropdownOptions: ["Other"]}
    ),
    "DropdownOptions"
    )

     

  • Meru Profile Picture
    4 on 07 Feb 2023 at 12:33:42
    Re: How to Add Other Choices in Dropdown List

    hey!

    Sorry, i have a problem with this solution.
    I dont why i put the option "Other", it disappear, also if I change places

    Meru_0-1675773140569.pngMeru_1-1675773211989.png

     

  • khaledfawzy Profile Picture
    20 on 13 Sep 2022 at 08:36:27
    Re: How to Add Other Choices in Dropdown List

    done thank you very much on solving this problem

  • v-liwei-msft Profile Picture
    on 04 May 2022 at 02:57:53
    Re: How to Add Other Choices in Dropdown List
    Hi @tanflwrz98  ,
    Could you please tell me if my reply help you solve this problem? I would be grateful if you can reply to me at your earliest convenience.
     
    Beat Regards,

    Levi

  • Verified answer
    v-liwei-msft Profile Picture
    on 29 Apr 2022 at 09:16:50
    Re: How to Add Other Choices in Dropdown List
     
    Could you please tell me if you want user can add options to a Dropdown control that is already connected to the data source?
    If you want the user to add options, I suggest you use the Combbox control. I have made a test for your reference:
    1.I used SharePoint as the data source to create a list named peopleGender. In the list, I created a column named gender with the data type of choices At this time, this column has only two values, male and female.
    vliweimsft_5-1651223765763.png

     

    2.In PowerApps, you can add an Editform that will include a combo box with the options.
    vliweimsft_6-1651223765765.png

     


    3.Then add an 'other' option change the items property of the dropdown to this code.
    vliweimsft_7-1651223765766.png

     

    4.Create a text input and place it directly over top of the combbox when an user selects ‘Other’ from the combbox a text input should appear where a custom value can be filled-in. 
    5.The text input should only be visible when the dropdown is not,you can use this code :Self.Selected.Value<>"Other" .
    6.Save the options entered by the user to the data source:
    Change the update property of the card where the combbox is located. Use the submitform function to upload user added options.vliweimsft_8-1651223765766.png

     

    vliweimsft_9-1651223765767.png

     

    I think this link will help you a lot :
     

    Beat Regards,

    Levi

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,011 Most Valuable Professional

Leaderboard