Importing Data (a list) into Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-297604%22%20slang%3D%22en-US%22%3EImporting%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-297604%22%20slang%3D%22en-US%22%3E%3CP%3ECan%26nbsp%3B%20I%26nbsp%3B%20import%20a%20list%20of%20names%26nbsp%3B%20into%20forms%20%2C%20so%20that%20a%20person%26nbsp%3B%20filing%26nbsp%3B%20out%20a%20form%20can%26nbsp%3B%20select%20a%20name%26nbsp%3B%20from%20that%26nbsp%3B%20list%20%3F%20Any%26nbsp%3B%20refernce%26nbsp%3B%20link%20to%20assist%26nbsp%3B%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-297604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-297619%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-297619%22%20slang%3D%22en-US%22%3ENo%20import%20data%20functions%20available%20at%20this%20time.%20The%20best%20you%20can%20do%20is%20copy%20and%20paste%20into%20the%20field%20on%20creation.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858697%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F251103%22%20target%3D%22_blank%22%3E%40Scuba19%3C%2FA%3E%26nbsp%3BHi%2C%20this%20is%20possible.%20In%20your%20form%2C%20select%20'Choice'%20then%20copy%20your%20list%20from%20Excel%20and%20paste%20into%20the%20first%20box%20that%20appears%20on%20the%20form.%20It%20will%20enter%20each%20option%20separately.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860664%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410251%22%20target%3D%22_blank%22%3E%40YDynamics%3C%2FA%3E%26nbsp%3B-%20the%20copy%20paste%20function%20works%20beautifully%20with%20Microsoft%20Forms%2C%20but%20not%20with%20Forms%20Pro%20at%20the%20moment.%20Hopefully%20something%20that%20will%20be%20added%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1211333%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1211333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370753%22%20target%3D%22_blank%22%3E%40Megan_V_Walker%3C%2FA%3E%26nbsp%3B%20It's%20been%20a%20while%20since%20you%20posted.%20This%20now%20kinda%20works.%20I%20ended%20up%20with%20a%20massive%20list%20in%20option%20one%20but%20then%20it%20broke%20it%20down%20into%20individual%20options.%20Then%20I%20just%20needed%20to%20delete%20the%20option%20one%20with%20it%20all%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1277952%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277952%22%20slang%3D%22en-US%22%3EI%20have%20a%20survey%20set%20up%20in%20forms%20that%20I%20intend%20to%20use%20to%20contact%20around%2030%2C000%20vulnerable%20customers%20during%20COVID%20lock%20down.%20Currently%20we're%20having%20to%20cut%20and%20paste%20data%20from%20Excel%20individually%20into%20forms%20for%20each%20survey.%20Is%20there%20a%20way%20to%20pull%20that%20data%20automatically%20so%20groups%20set%20up%20in%20teams%20can%20just%20open%20a%20form%20pre%20populated%20and%20complete%20a%20survey%20with%20the%20next%20customer%20data%20pulling%20through%20once%20completed%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2079838%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607579%22%20target%3D%22_blank%22%3E%40Steven_Nichol%3C%2FA%3E%26nbsp%3Bcan%20we%20use%20PowerApp%20to%20fill%20in%20that%20data%20in%20the%20back%20end%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089732%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F936560%22%20target%3D%22_blank%22%3E%40DawnBurgess%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607579%22%20target%3D%22_blank%22%3E%40Steven_Nichol%3C%2FA%3E%26nbsp%3B%20no%20Power%20Apps%20wouldn't%20help%20you%20here%2C%20there%20is%20no%20way%20to%20pre-populate%20your%20data%20in%20Forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094336%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BSad%20day.%26nbsp%3B%20Is%20there%20a%20form%20tool%20that%20we%20could%20utilize%20in%20an%20online%20environment%20so%20that%20we%20keep%20people%20out%20of%20our%20spreadsheet%20since%20Access%20doesn't%20play%20nice%20online%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2097792%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Data%20(a%20list)%20into%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2097792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F936560%22%20target%3D%22_blank%22%3E%40DawnBurgess%3C%2FA%3E%26nbsp%3Binstead%20of%20using%20Microsoft%20Forms%20I%20would%20look%20at%20using%20Power%20Apps%20for%20the%20whole%20thing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Can  I  import a list of names  into forms , so that a person  filing  out a form can  select a name  from that  list ? Any  refernce  link to assist  ? 

9 Replies
No import data functions available at this time. The best you can do is copy and paste into the field on creation.

@Scuba19 Hi, this is possible. In your form, select 'Choice' then copy your list from Excel and paste into the first box that appears on the form. It will enter each option separately. 

@YDynamics - the copy paste function works beautifully with Microsoft Forms, but not with Forms Pro at the moment. Hopefully something that will be added in the future. 

@Megan_V_Walker  It's been a while since you posted. This now kinda works. I ended up with a massive list in option one but then it broke it down into individual options. Then I just needed to delete the option one with it all in.

I have a survey set up in forms that I intend to use to contact around 30,000 vulnerable customers during COVID lock down. Currently we're having to cut and paste data from Excel individually into forms for each survey. Is there a way to pull that data automatically so groups set up in teams can just open a form pre populated and complete a survey with the next customer data pulling through once completed ?

@Steven_Nichol can we use PowerApp to fill in that data in the back end?  

 

@DawnBurgess @Steven_Nichol  no Power Apps wouldn't help you here, there is no way to pre-populate your data in Forms.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Sad day.  Is there a form tool that we could utilize in an online environment so that we keep people out of our spreadsheet since Access doesn't play nice online?

@DawnBurgess instead of using Microsoft Forms I would look at using Power Apps for the whole thing.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User