Adding multiple names to PowerAps, Share Point Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-1918416%22%20slang%3D%22en-US%22%3EAdding%20multiple%20names%20to%20PowerAps%2C%20Share%20Point%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918416%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%20How%20can%20I%20add%20a%20few%20hundred%20names%20at%20one%20time%20to%20a%20Sharepoint%20list%20and%20PowerApp%3F%26nbsp%3B%20%26nbsp%3BCurrently%2C%26nbsp%3B%20I%20only%20see%20the%20ability%20to%20add%20one%20name%20at%20a%20time.%26nbsp%3B%20%26nbsp%3BIt%20is%20necessary%20at%20my%20job%20to%20be%20able%20to%20add%20hundreds%20of%20names%20to%20update%20Sharepoint%20list%20and%20apps.%26nbsp%3B%20Please%20advise.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1918416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921726%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20multiple%20names%20to%20PowerAps%2C%20Share%20Point%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921726%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F876376%22%20target%3D%22_blank%22%3E%40candy735%3C%2FA%3E%26nbsp%3BIs%20this%20something%20that%20you%20would%20have%20to%20do%20regularly%20or%20just%20once%20to%20get%20started%3F%20Where%20is%20the%20data%20located%3F%20If%20you%20can%20get%20it%20in%20an%20Excel%20sheet%20you%20can%20copy%20it%20from%20there%20and%20paste%20it%20in%20the%20list%20in%20%3CSTRONG%3Equick%20edit%20view%3C%2FSTRONG%3E.%20You%20would%20have%20to%20make%20sure%20you%20have%20the%20same%20columns%20in%20your%20Excel%20sheet%20that%20you%20do%20in%20your%20list.%3C%2FP%3E%3CP%3EHave%20a%20look%20at%20%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2F3-ways-import-excel-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ethis%20webpage%3C%2FA%3E%20for%20other%20ways%20to%20import%20data%20into%20a%20SharePoint%20list.%20Mind%20you%2C%20there%20are%20some%20disadvantages%20to%20some%20of%20the%20ways%20mentioned%20on%20that%20webpage%2C%20for%20example%20most%20of%20them%20seem%20to%20create%20a%20%3CEM%3Enew%3C%2FEM%3E%20list%2C%20so%20they%20would%20not%20be%20suited%20if%20you%20need%20to%20append%20large%20amounts%20of%20data%20to%20an%20%3CEM%3Eexisting%3C%2FEM%3E%20list.%3C%2FP%3E%3CP%3EPersonally%20I%20would%20go%20for%20the%20copy%2Fpaste%20way%20into%20Quick%20Edit%20View.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20the%20PowerApps%20part%20of%20your%20question%2C%20it%20is%20not%20clear%20to%20me%20what%20exactly%20you%20mean.%20Ideally%20your%20app%20would%20get%20its%20data%20from%20a%20SharePoint%20list%20or%20other%20data%20source%2C%20you%20would%20not%20add%20it%20directly%20into%20the%20app%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,  How can I add a few hundred names at one time to a Sharepoint list and PowerApp?   Currently,  I only see the ability to add one name at a time.   It is necessary at my job to be able to add hundreds of names to update Sharepoint list and apps.  Please advise.  Thank you!

2 Replies

@candy735 Is this something that you would have to do regularly or just once to get started? Where is the data located? If you can get it in an Excel sheet you can copy it from there and paste it in the list in quick edit view. You would have to make sure you have the same columns in your Excel sheet that you do in your list.

Have a look at this webpage for other ways to import data into a SharePoint list. Mind you, there are some disadvantages to some of the ways mentioned on that webpage, for example most of them seem to create a new list, so they would not be suited if you need to append large amounts of data to an existing list.

Personally I would go for the copy/paste way into Quick Edit View.

 

As for the PowerApps part of your question, it is not clear to me what exactly you mean. Ideally your app would get its data from a SharePoint list or other data source, you would not add it directly into the app itself.

@OliverR-1982  Hi thank you.  It is not in an excel form, it is in a Sharepoint document.  It would need regular updating per semester of hundreds of names.  Is there a private way I can send you a screenshot, etc?  Thank you.