Linking a dropdown box to live data for Forms

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
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