Linking a dropdown box to live data for Forms

Question

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

hannahbirch · Answer

trevor2000&nbsp;&nbsp;This is not possible, but it looks like you can do this by using the MS Power Apps (Canvas).&nbsp;That is the conclusion I have come to and will try that now. It is MS LowCode / No Code. So may look more complex but maybe worth exploring.&nbsp;Good luck.

chrishoardmvp · Answer

Hi Trevor2000,AFAIK, not possible currently via Forms. However, there is a uservoices surfacing for using excel as a source for drop downs herehttps://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/37054144-use-excel-as-source-for-drop-downs-on-formAnd from SharePoint and Excel herehttps://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/37988455-drop-down-menu-lookup-from-sharepoint-list-or-exceI 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 listhttps://jobs.collab365.community/how-to-create-a-user-registration-form-using-powerapps-flow-sharepoint-lists/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

trevor2000 · Answer

Many thanks&nbsp;ChrisHoardMVP&nbsp;

rober2235 · Answer

ChrisHoardMVP&nbsp;thank you for posting the links to the user voice here. Since Microsoft has now closed the old user voice forum, here is a link to the corresponding idea in the new forum for reference &nbsp;https://feedbackportal.microsoft.com/feedback/idea/3211fc75-4cbe-ed11-83ff-000d3a1f8608&nbsp;

Forum Discussion

Linking a dropdown box to live data for Forms

Resources