Nov 04 2021
11:16 AM
- last edited on
Aug 03 2023
06:49 PM
by
TechCommunityAP
Nov 04 2021
11:16 AM
- last edited on
Aug 03 2023
06:49 PM
by
TechCommunityAP
I've built a form with a drop down, multiple choice selection. The list is a long list of US states.
It'd be great if a user could select the drop-down, and begin typing the first few letters of a state, and have it start reducing the answers. For example, typing "Ar" would filter the results down to "Arizona" and "Arkansas" to make it faster for filling out the form.
This is just an example of how'd it be useful. The real use case is with a lost list of server names, all sorted by state/location. The hunt and peck for a given server takes a long time, but if we could quickly sort down to at least a state's worth of options via that dropdown sorting, that'd be awesome.
Thanks
Nov 06 2021 07:01 AM
@CatPrizbrrrs while the filtering of dropdowns is not available in Forms you might want to consider creating your form in Power Apps where such a filter is very easy to do. You can then link it to a flow in Power Automate, another SharePoint list etc to store whatever data is stored in the form. Have a look at the attached video where I've done a very quick demo of the filtering of countries based on the letters the user enters into the text box at the top of the screen.
There are very good introductory (and more advanced) Power Apps videos on YouTube by Shane Young and others.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Nov 09 2021 02:41 PM