When creating a Sharepoint survey, how can I have an automatically self-updating dropdown list of answers choices?

Question

I am working with SharePoint and creating a survey with it. I would need to have a question where the choices for answers update automatically based on an outside source (either excel or SharePoint List).

The survey is to act as a feedback form for a reporting platform. As such, we want the user to start filling the survey by specifying which report he is evaluating using a dropdown list. Since we are creating new reports quite often, I would like that this dropdown list automatically updates itself every time a new report is created.

We would maintain an excel or SharePoint list with the names of the reports (based on what is easier to link to the SharePoint survey).

Any idea? Thanks a lot!

Cheers!

Answer 1

This is possible by creating a question of type "Lookup" and creating a list of reports in SharePoint (custom list). Using a lookup column you have to option to add or update reports in your reports list. All changes made to your list are directly visible in your survey.