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

%3CLINGO-SUB%20id%3D%22lingo-sub-358335%22%20slang%3D%22en-US%22%3ECan%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358335%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20there%20is%20any%20way%20to%20get%20a%20Form%20to%20read%20choices%20for%20a%20question%20from%20an%20external%20source%20say%20a%20SharePoint%20online%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20make%20it%20easier%20to%20manage%20the%20list%20without%20having%20to%20update%20the%20form%20each%20time%20new%20options%20were%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20I%20had%20a%20form%20with%20a%20question%20asking%20for%20budget%20code%20to%20be%20entered%2C%20i%20would%20rather%20pull%20a%20list%20from%20a%20common%20external%20source%20than%20have%20to%20remember%20to%20update%20the%20form%20each%20time%20a%20code%20is%20added%20or%20removed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3EJonathan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358335%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359713%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359713%22%20slang%3D%22en-US%22%3EThanks%20All%2C%20I'll%20pop%20something%20in%20uservoice%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358596%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358596%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F268261%22%20target%3D%22_blank%22%3E%40jonathangledhill%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F184117%22%20target%3D%22_blank%22%3E%40Maruthi%20Gadde%3C%2FA%3Eis%20right%20that%20there's%20currently%20no%20way%20to%20source%20data%20from%20external%20sources%20to%20use%20in%20Forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20that%20it%20logically%20may%20be%20a%20future%20option%20but%20for%20now%20you'll%20have%20to%20keep%20doing%20the%20changes%20in%20Forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358548%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358548%22%20slang%3D%22en-US%22%3EI%20dont%20think%20you%20can%20have%20a%20Question%20in%20the%20Form%20pull%20from%20a%20DataSource.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20only%20have%20the%20option%20to%20automatically%20update%20response%20to%20an%20Excel%20in%20SharePoint%20or%20OneDrive%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171969%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171969%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F268261%22%20target%3D%22_blank%22%3E%40jonathangledhill%3C%2FA%3E%26nbsp%3B%20%26nbsp%3Bany%20answer%20from%20microsoft%26nbsp%3B%20with%20a%20solution%20to%20this%20obvious%20request%20yet%3F%20My%20company%20needs%20simple%20solutions%20like%20theese%20and%20this%20looks%20still%20pending%20in%202020.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1907819%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1907819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F277935%22%20target%3D%22_blank%22%3E%40Manuel_Angelini%3C%2FA%3E%26nbsp%3BBeen%20looking%20for%20this%20feature%20as%20well....%20any%20news%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1916684%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1916684%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F875070%22%20target%3D%22_blank%22%3E%40Bigshow77%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20yet%20AFAIK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114957%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20populate%20form%20choices%20from%20external%20list%20i.e.%20Sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114957%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20would%20be%20great%20to%20hve%20a%20feature%20as%20the%20one%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F268261%22%20target%3D%22_blank%22%3E%40jonathangledhill%3C%2FA%3E%20mentions.%26nbsp%3B%20populate%20excel%20values%20as%20options%20into%20mcrosoft%20forms%20answer%20will%20make%20it%20much%20richer.%26nbsp%3B%20It%20would%20also%20be%20great%20to%26nbsp%3Bpopulate%20access%20values%20as%20options%20into%20mcrosoft%20forms%20answer%20and%20other%20tools%20such%20as%20these.%20Is%20there%20a%20timeline%20to%20do%20this%20from%20microsoft%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

Jonathan

14 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.

 

Cheers

Damien

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.

 

Cheers

Damien

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?

Form is still getting hanged up when there are more option in drop down.
In desperate need to auto populate drop down list from external source.

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.

@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)

@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.

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.

@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)

I presume I just did it wrong before because it added all of the countries into the first answer option. Once again thank you very much