Allow Fill-in choices in PowerApps Drop-down menu with SharePoint choice field

Problem:

You are customizing SharePoint Form using the PowerApps.

As you may have noticed, PowerApps Drop-Down menu (Combo box) does not support SharePoint Choice fields property for Allow ‘Fill-in’ choices by the default.

Solution:

In PowerApps, create a logic that stores another text field value to Drop-down menu value. That way you can store the users fill-in choices to the SharePoint List in PowerApps forms.

In my example I have created SharePoint List which contains the following fields:

  • Title
  • My Drop-down menu (choice field)
    • values (choice 1, Choice 2, Other, please give your own value)
  • HiddenTextField (Single line of text)

In PowerApps I have set If-statement to the HiddenTextField Visible-property.

If(DataCardValue2.Selected.Value ="Other, please give your own value", true, false)

So, when the user select value “Other, please give your own value” from the “My Drop-down menu”, HiddenTextField is shown in the form.

Then I have set If-statement to My Drop-down-menu (Combo box) Update-event.

If(DataCardValue2.Selected.Value="Other, please give your own value", {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id: 0,
   Value: DataCardValue4.Text
  },DataCardValue2.Selected) 

So, when the item is saved in SharePoint list, PowerApps form takes the value from the HiddenTextField and saves it to the My Drop-down menu as “Fill-in choice”.

Conclusions

That’s it. You can store users Fill-in choices to SharePoint list also in PowerApps forms.

4 thoughts on “Allow Fill-in choices in PowerApps Drop-down menu with SharePoint choice field

  1. Eric

    How do I set it so the text input is stored in the column, but the value isn’t added to the drop-down choice column for the next submitter? I want to store the “Other” value, but not add it to the original drop-down choice column.

    Like

      1. Eric

        Yes I found a way to do it. First, I didn’t need a hidden field in SharePoint. I just added fill in box that is not connected to any field in SharePoint.

        I changed the Update code in yours to set value to this: Value: Concatenate(“Other: “,TextInput1.Text)

        Then in the “Items” value I added a filter to filter out “Other: ” text: Filter(Choices([@’Invoice Processing Requests’].Cost_x0020_Object),Not(“Other:” in Value))

        It stores the value in the same SharePoint field but doesn’t show it in the drop-down for new items.

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s