SPO searchable dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-978666%22%20slang%3D%22en-US%22%3ESPO%20searchable%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978666%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Gurus%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20reading%20the%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20with%20applicants.%20In%20the%20beginning%20the%20list%20will%20probably%20only%20contain%20a%20few%20names%2C%20but%20in%20time%20it%20should%20have%20thousands%20of%20names%3A%20lst_names.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20column%2C%20in%20a%20different%20list%20named%20lst_results%2C%20that%20fetches%20the%20names%20from%20lst_names.%20As%20I%20see%20things%20at%20the%20moment%20the%20user%20has%20to%20scroll%20down%20the%20list%20to%20find%20the%20right%20name.%20If%20I%20end%20up%20with%20thousands%20of%20names%2C%20the%20user%20will%20have%20to%20scroll%20down%20a%20long%20list%20to%20get%20the%20right%20name.%20%3CSTRONG%3EIs%20there%20a%20way%20to%20have%20a%20searchable%20dropdown%20list%20as%20it%20was%20in%20SP13%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3CP%3ELeonel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-978666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDropdown%20list%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-978987%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20searchable%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F216718%22%20target%3D%22_blank%22%3E%40Leonel%20GUZMAN%3C%2FA%3E%26nbsp%3Bwith%20a%20customised%20SharePoint%20form%20using%20PowerApps%20you%20can%20have%20cascading%20dropdowns%20so%20I%20recommend%20you%20investigate%20that.%20There%20are%20lots%20of%20YouTube%20videos%20showing%20how%20to%20do%20this%20and%20those%20from%20Shane%20Young%20are%20always%20very%20good%2C%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DpkZG2boN7jQ%26amp%3Bt%3D566s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DpkZG2boN7jQ%26amp%3Bt%3D566s%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Dear Gurus,

 

Thank you for reading the post.

 

I have a list with applicants. In the beginning the list will probably only contain a few names, but in time it should have thousands of names: lst_names.

 

I have another column, in a different list named lst_results, that fetches the names from lst_names. As I see things at the moment the user has to scroll down the list to find the right name. If I end up with thousands of names, the user will have to scroll down a long list to get the right name. Is there a way to have a searchable dropdown list as it was in SP13?

 

Thank you very much!

Leonel

1 Reply

@Leonel GUZMAN with a customised SharePoint form using PowerApps you can have cascading dropdowns so I recommend you investigate that. There are lots of YouTube videos showing how to do this and those from Shane Young are always very good, for example https://www.youtube.com/watch?v=pkZG2boN7jQ&t=566s

 

Rob
Los Gallardos
Microsoft Flow Community Super User

New version available here - https://www.youtube.com/watch?v=SKMwayf_cuMIn today's show, you learn about PowerApps cascading dropdown menus. Nothing fancy bu...