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

6 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?