Power Apps - Building Power Apps

Form using "other"

(1) Share

Report

Posted on by joel914823

551

I have a Sharepoint List as a source.

I created a Form in Power Apps.

Column is called "Change Reason" but set as a single line of text in SharePoint.

Is there a way to make it a choice drop down in the PowerApps Form with reasons (Choice A, Choice B, Choice C, Other). If other is selected, then gives you option to free text it out and it puts the information into the same column "Change Reason"? Almost like it does when you create a form in Forms or Customer Voice? Thank you.

Categories:

General Questions

All responses (2)

Answers (0)

Suggested answer

Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report
Form using "other"

Yes, it is possible. But its not simplistic. Here are the steps required

1) Add a card for Column "Change Reason" to the form and unlock the Card.

2) Add a Dropdown to the Unlocked card and set its Item value to

Table({Value: "Other"},{Value: "Choice A"},{Value: "Choice B"},{Value: "Choice C"})

Set the default value of the Dropdown to "Choice A"

3) Set the DisplayMode property of the TextInput control in the form to

If(Dropdown1.Selected.Value="Other", DisplayMode.Edit,DisplayMode.Disabled)

4) Change the Update property of the card to the following

If(Dropdown1.Selected.Value = "Other",TextInput1_1.Text, Dropdown2_1.Selected.Value)

5) Fix spacing inside the Card and any other errors that may be present
Suggested answer

Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (0)

Report

Form using "other"

HI,

So, yes you could do that. There are some not so much caveats but different ways to do it.

1) I would create a Collection, that has Choice A, B etc in it by default. Use the Screen OnVisible to pre-populate it

add that as the Items property for the Drop down

2) have a label, + Icon and text input invisible and have the visible set to something like

MyDropDown.Selected.ColumnName Or SelectedText depending on your collection. = "Other"

you dont need to add = true or anything just the above

3) when the person types in a value in the text box, set the + Icon visible to (for adding the new option)

!IsBlank(MyOtherInput.Text And !Contains(MyOtherCollection, MyOtherInput.Text) or something like this so they cannot add the same thing 2 or more times

This will then make the + visible

4) in the + Onselect

do a Collect(MyChoicesCollection, MyOtherInput.Text)

then have it reset(MyOtherInput.Text) so that they cannot add the same thing again

5) Now it will be in the Dropdown for them to select. Or if you want to auto select it as the default, once they save it we can do that too.

But now they can add any they want, and you just have to save the Selected value into the SP List since its a text.