Use excel as source for drop-downs on form
It would be nice if the form could use an excel spreadsheet as a data-source, this would allow for drop-downs that could populate other fields based on a choice.
I can't believe this doesn't already exist! Please add this ability. It will make our forms so much better!
Kevin Faulmann commented
Ability to dynamically populate from SharePoint List Column would be great.
Todd Warrington commented
I'm on board with this completely. We need a way to have dynamic lists that can be updated and managed without having to give someone access to the form designer.
FWIW, I would like this or even a SharePoint List so that other users could modify and dynamically update the choices in the drop down.
This is a great idea as I am trying to setup a Microsoft form with several dropdown's and one of them will have over 900 entries! Having a dropdown dynamically update and check a list / column in Excel would work very well.
Ideally I would like the dropdown box from forms to read the data list from a distribution list in Active Directory - that would be fantastic.