Answered

How to Add Other Choices in Dropdown List

(0) Share

Report

Posted on by tanflwrz98

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-liwei-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @tanflwrz98 ,

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.

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

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

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.

I think this link will help you a lot :
https://www.matthewdevaney.com/create-a-dropdown-with-an-other-option-in-power-apps/

Beat Regards,
Levi

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
khaledfawzy 20 on at

Like (0)

Report
Copy link

Link copied!

done thank you very much on solving this problem

Was this reply helpful? Yes No
Meru 4 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
khaledfawzy 20 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mrwilliams 50 on at

Like (0)

Report
Copy link

Link copied!
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:
What am I missing?

Thanks

Was this reply helpful? Yes No
MatthewEdwards 14 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No