Team Forms

Drop-down menus are typically used to present a predefined list of values for users to select from. However, in some business scenarios, this list may not include all the possible values, requiring users to manually input their own.

Unfortunately, Team Forms  do not natively support user-defined inputs in drop-down menus (and SharePoint drop-downs). To work around this limitation, you can combine a drop-down menu with a conditional text field to allow users to enter custom values when needed.

Below are the recommended approaches for both standard and SharePoint-based drop-down menus.

Note: Team Forms does have plans to better support manually entered user values in drop-down menus in the future.

To enable custom user input alongside a standard drop-down menu, follow these steps:

Add a Drop-Down Menu - Drag and drop a drop-down menu component into your form. Configure the list of options in the Data tab as usual.

Add an “Other” Option - At the end of your options list, add an additional value labeled "Other".

Add a Text Field - Drag and drop a text field onto your form. This field will allow the user to manually enter a value if their desired option is not in the list.

Set Conditional Visibility - Go to the Conditional tab of the text field and configure it to only show when the drop-down selection is "other".

1. Add a Drop-Down Menu - Drag and drop a drop-down menu component into your form. Configure the list of options in the Data tab as usual.
2. Add an “Other” Option - At the end of your options list, add an additional value labeled "Other".
3. Add a Text Field - Drag and drop a text field onto your form. This field will allow the user to manually enter a value if their desired option is not in the list.
4. Set Conditional Visibility - Go to the Conditional tab of the text field and configure it to only show when the drop-down selection is "other".

For drop-downs sourced from SharePoint data (e.g. a SharePoint list or Excel file), the process is slightly different:

Add a SharePoint Drop-Down - Drag and drop a SharePoint data component into your form. Configure it to pull from the appropriate data source.

Update the Data Source - In SharePoint (or Excel), edit the underlying data source to add a new item labeled “Other”.

Add a Text Field - Drag and drop a text field into your form, similar to the standard drop-down method.

Set Conditional Visibility with Advanced Logic - In the Conditional tab of the text field, use an advanced expression to show the text field only when the user selects "Other". For example:

1. Add a SharePoint Drop-Down - Drag and drop a SharePoint data component into your form. Configure it to pull from the appropriate data source.
2. Update the Data Source - In SharePoint (or Excel), edit the underlying data source to add a new item labeled “Other”.
3. Add a Text Field - Drag and drop a text field into your form, similar to the standard drop-down method.
4. Set Conditional Visibility with Advanced Logic - In the Conditional tab of the text field, use an advanced expression to show the text field only when the user selects "Other". For example:

Allow Users to Manually Input Data into a Drop-Down Menu

Standard Drop-Down Menu

SharePoint Drop-Down Menu