Can you populate form choices from external list i.e. Sharepoint?

Occasional Contributor



Wondering if there is any way to get a Form to read choices for a question from an external source say a SharePoint online list?


This would make it easier to manage the list without having to update the form each time new options were added.


For example, if I had a form with a question asking for budget code to be entered, i would rather pull a list from a common external source than have to remember to update the form each time a code is added or removed?


Thanks in advance.


7 Replies
I dont think you can have a Question in the Form pull from a DataSource.

You only have the option to automatically update response to an Excel in SharePoint or OneDrive

Hi @jonathangledhill 


@Maruthi Gaddeis right that there's currently no way to source data from external sources to use in Forms.


I suspect that it logically may be a future option but for now you'll have to keep doing the changes in Forms.




Thanks All, I'll pop something in uservoice :)

@jonathangledhill   any answer from microsoft  with a solution to this obvious request yet? My company needs simple solutions like theese and this looks still pending in 2020.

@Manuel_Angelini Been looking for this feature as well.... any news?

Hi @Bigshow77 


Not yet AFAIK.




It would be great to hve a feature as the one @jonathangledhill mentions.  populate excel values as options into mcrosoft forms answer will make it much richer.  It would also be great to populate access values as options into mcrosoft forms answer and other tools such as these. Is there a timeline to do this from microsoft?