Forum Discussion

jonathangledhill

Copper Contributor

Feb 28, 2019

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

Hi. 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 havin...

microsoft forms

Copper Contributor

Nov 19, 2021

Would love this as well. I was trying to make a form with a question for the country of origin and putting every country in a dropdown list is not worth the time.

RobElliott
Silver Contributor
Nov 19, 2021
PRossberg you don't have to enter the countries individually, you can drag and drop them all from Excel straight into your choice question in 1 go.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- PRossberg
  Copper Contributor
  Nov 23, 2021
  I just discovered that you can only drag and drop one answer option at a time so this sadly does not help much in the end.
  - RobElliott
    Silver Contributor
    Nov 23, 2021
    PRossberg not so. Select your list of items from Excel and copy (ctrl+c), click in the Option 1 answer and paste them in (ctrl+v) as I demonstrate in the attached video.
    
    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
    ChoiceFromExcel.mp42.4 MB
- PRossberg
  Copper Contributor
  Nov 19, 2021
  RobElliott oh didn't know that thanks. That makes the whole process a little easier but sadly doesn't solve my next problem of asking about spoken languages since that would be a multiple choice answer at would be way better in a drop down but sadly those can't be multiple choice. I would love the option for a new possible "Other" answer to pop up whenever a previous one is filled out so the person can fill out whatever languages they speak but don't have to do so in a single text box.
  But thanks for your help so far I will keep that in mind.

Resources