Linking a dropdown box to live data for Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-968470%22%20slang%3D%22en-US%22%3ELinking%20a%20dropdown%20box%20to%20live%20data%20for%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968470%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20in%20the%20process%20of%20setting%20up%20some%20new%20Forms%20for%20our%20teams.%20I%20am%20hoping%20to%20find%20a%20way%20to%20add%20a%20dropdown%20box%20with%20names%20from%20another%20source%20such%20as%20an%20Excel%20spreadsheet.%20In%20Microsoft%20Forms%20when%20I%20select%20a%20Dropdown%20box%20there%20doesn't%20seem%20to%20be%20a%20way%20to%20import%20any%20data%20and%20any%20entries%20have%20to%20be%20done%20one%20at%20a%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20hoping%20to%20dynamically%20link%20a%20dropdown%20box%20to%20one%20of%20our%20distribution%20groups%20or%20if%20this%20is%20not%20possible%20to%20have%20the%20dropdown%20box%20read%20from%20a%20Excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20distribution%20group%20has%20over%20900%20members%20-%20so%20you%20can%20see%20why%20I%20do%20not%20want%20to%20do%20this%20one%20by%20one!%20If%20there%20is%20a%20way%20to%20do%20this%20using%20Forms%20%2F%20Power%20Apps%20or%20anything%20within%20Office%20365%20please%20let%20me%20know!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-968470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-975992%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20a%20dropdown%20box%20to%20live%20data%20for%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-975992%22%20slang%3D%22en-US%22%3EHi%20Trevor2000%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAFAIK%2C%20not%20possible%20currently%20via%20Forms.%20However%2C%20there%20is%20a%20uservoices%20surfacing%20for%20using%20excel%20as%20a%20source%20for%20drop%20downs%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37054144-use-excel-as-source-for-drop-downs-on-form%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37054144-use-excel-as-source-for-drop-downs-on-form%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20from%20SharePoint%20and%20Excel%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37988455-drop-down-menu-lookup-from-sharepoint-list-or-exce%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37988455-drop-down-menu-lookup-from-sharepoint-list-or-exce%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20recommend%20voting%20to%20push%20these%20up%20the%20agenda.%20As%20Uservoices%20can%20take%20some%20time%20to%20be%20reviewed%20and%20picked%20up%2C%20if%20at%20all%2C%20I%20would%20raise%20them%20at%20the%20next%20AMA.%20You%20could%20look%20at%20going%20down%20the%20avenue%20with%20Powerapps%20and%20a%20SharePoint%20list%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fjobs.collab365.community%2Fhow-to-create-a-user-registration-form-using-powerapps-flow-sharepoint-lists%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjobs.collab365.community%2Fhow-to-create-a-user-registration-form-using-powerapps-flow-sharepoint-lists%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fbaizini-it.com%2Fblog%2Findex.php%2F2017%2F09%2F28%2Fpowerapps-101-create-your-own-forms%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fbaizini-it.com%2Fblog%2Findex.php%2F2017%2F09%2F28%2Fpowerapps-101-create-your-own-forms%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20helps%20to%20answer%20your%20question!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-994847%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20a%20dropdown%20box%20to%20live%20data%20for%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994847%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am in the process of setting up some new Forms for our teams. I am hoping to find a way to add a dropdown box with names from another source such as an Excel spreadsheet. In Microsoft Forms when I select a Dropdown box there doesn't seem to be a way to import any data and any entries have to be done one at a time. 

 

I was hoping to dynamically link a dropdown box to one of our distribution groups or if this is not possible to have the dropdown box read from a Excel spreadsheet.

 

The distribution group has over 900 members - so you can see why I do not want to do this one by one! If there is a way to do this using Forms / Power Apps or anything within Office 365 please let me know!

 

Thanks

2 Replies
Highlighted
Hi Trevor2000,

AFAIK, not possible currently via Forms. However, there is a uservoices surfacing for using excel as a source for drop downs here

https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

And from SharePoint and Excel here

https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

I would recommend voting to push these up the agenda. As Uservoices can take some time to be reviewed and picked up, if at all, I would raise them at the next AMA. You could look at going down the avenue with Powerapps and a SharePoint list

https://jobs.collab365.community/how-to-create-a-user-registration-form-using-powerapps-flow-sharepo...
https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/

Hope that helps to answer your question!

Best, Chris
Highlighted