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!