Forum Discussion
Linking a dropdown box to live data for Forms
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 ...
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/suggestions/37054144-use-excel-as-source-for-drop-downs-on-form
And from SharePoint and Excel here
https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/37988455-drop-down-menu-lookup-from-sharepoint-list-or-exce
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-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
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/suggestions/37054144-use-excel-as-source-for-drop-downs-on-form
And from SharePoint and Excel here
https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/37988455-drop-down-menu-lookup-from-sharepoint-list-or-exce
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-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
Many thanks ChrisHoardMVP