cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Fill-in option on dropdown control

Hi team,

 

How can I add a text value on a dropdown field where the coloumn setting has been set to allow the fill-in option. 

Dropdown.SearchText = Textbox.Text didn't work for me especially when the user has selected something on the dropdown option.

 

Storage.PNG

 

Please help! 😄 

 

The Goal: I want them to save the data on the text field when "Other" is selected from the dropwdown rather than the word "Other" - but I still need to save the other options on the dropdown list.

7 REPLIES 7
CarlosFigueira
Power Apps
Power Apps

You can use an expression like this one to retrieve the value of the combo box (if it's not set to 'Other') or the text field (if the combo box is set to other:

If(
    ComboBox1.Selected.Value = "Other",
    TextInput1.Text,
    ComboBox1.Selected.Value)

Where 'ComboBox1' and 'TextInput1' are the names of the controls (you may need to change it if the controls in your app are named differently).

Anonymous
Not applicable

Hi Carlos

 

Thank you for responding.

Yes this logic was definitely considerred however, when I placed it on OnSelect and also tried OnChange that value did not change - it was still stuck on "Other". I can only allow 1 value on the dropdown.

 

I might have been putting my logic statement in the wrong field.

v-xida-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want to add a text field value into your Dropdown field when "Other" is selected from the dropwdown (Combo box control)?

Could you please share a bit more about the Dropdown field that you mentioned? Is it a Choice type column in your SP list?

Further, could you please share a bit more about your app's configuration?

 

I suppose that you custom a form for your SP list using PowerApps on your side, is it true?

 

I have made a test on my side, please take a try with the following workaround:1.JPG

 

  • Unlock the Data card control which contains the Combo box cnotrol (On your side, it is "Where will your data be stored").
  • Set the Update property of the Data card control (which contains the Combo box control) to following formula:
If(
DataCardValue3.Selected.Value="Other",
{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: 0, Value: DataCardValue4.Text },
DataCardValue3.Selected
)

Note: The DataCardValue3 represents the Combo box control on your side, the DataCardValue4 represents the Text filed on your side.

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Response in blue

Do you want to add a text field value into your Dropdown field when "Other" is selected from the dropwdown (Combo box control)?

 

No I do not. I want it to ignore "Other" which is an array item of the Dropdown field and instead save the text they put in the Textbox field which only appears if "Other" is selected. I don’t want their text to be added to the array but simply to save it on the list.

 

Could you please share a bit more about the Dropdown field that you mentioned? Is it a Choice type column in your SP list?

Yes it is.

 

Further, could you please share a bit more about your app's configuration?

It’s a custom list form

 

I suppose that you custom a form for your SP list using PowerApps on your side, is it true?

Yes it is

 

I have made a test on my side, please take a try with the following workaround:

It didn’t work ☹

 

The error states it’s asking for a record value.

I have a very annoying workaround to this problem however I rather implement it right and I know there must be an easy way since I have allowed the column to have the Fill-in option.

 

I would like to know this also.

 

I have my TextInput control not visiable unless "Other" is selected in ther DropDown. (Normal DropDown control)

 

How do I save the TextInput text as the Value for the DataCard ELSE use selected Item on the Drop Down?

 

 

mdevaney
Super User
Super User

@clearstream 
I can show you how to make a dropdown control with an 'other' option a user can choose to fill-in a custom value.  Check out the article below for instructions.

Article - Create A Dropdown With An Other Option In Power Apps
https://matthewdevaney.com/create-a-dropdown-with-an-other-option-in-power-apps/



powerapps-choicesother-10-1.gif

takolota
Helper II
Helper II

I used a text box set on-top of a drop-down to achieve this:

takolota_0-1622161319575.png

So add a drop-down to a card with a text input and set the text input default to the dropdown.selected.value.

Then right-click the text box and reorder it by bringing it to front. Set the drop down Y position = text input Y position. Then drag the text box over the text portion of the drop-down, leaving the down arrow button visible.

If you don’t want the text box to fill with the 1st dropdown value, set AllowEmptySelection property on the dropdown to true and the Default property to "".

 

Now you should be able to input text or use the dropdown.

(I then have the drop-down options set to retrieve all distinct submissions for the column I’m using.)

 

 

I’ve also seen some solutions with combo-boxes that may result in something similar: https://powerusers.microsoft.com/t5/Building-Power-Apps/Adding-user-input-to-Allowed-Values-Dropdown... 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,817)