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!



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

And from SharePoint and Excel here

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

Hope that helps to answer your question!

Best, Chris