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.
Rob Poulin commented
When the excel report is generated from the Forms, it contains certain columns that I really do not need (Points and Feedback). I have removed them but they a re-generated again when a new response is submitted. Is it possible to permanently delete these columns? Thank you.
Ron M commented
Our goal is to leverage forms to perform assessments by creating and distributing customized questionnaires to my suppliers as a part of the procurement process. I realize there are many SaaS solutions out there, but I prefer to keep this in-house using the tools already licensed.
The questions will be grouped by section and sorted sequentially and could be in multiple parts. Some are questions will have a range of acceptable values such as: "yes", "no", "maybe", or "not-aware" while others may be a numerical value from 1 to 5".
A question box will dynamically expand or open to allow feedback if selection of the acceptable response value is maybe or not aware.
Question are stored in an excel workbook. Is it possible to import the questions from my excel sheet?
Weighted Scoring: Can questions that require a numerical value be used to calculate a weighted value and stored with the response. When using this feature, the weighted score will be dynamically calculated and totals summarized.
Jeroen De Bruyne commented
This is the biggest road block for me to switch over from Google Forms to MS...
Andres Caicedo commented
I thought this already existed. It would be a fantastic alternative to allow dynamically populate drop-downs with large amount of items from Excel.
It will also help reduce maintenance on forms with drop-downs that often change for instance.
This would be so fantastic if available, could then use it to populate the form with other details based on the dropdown selection, hopefully allowing it to basically act like a front end for the Excel sheet to either add OR edit details in the sheet.
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.