cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Bulk uploading items into a list

Hello,

 

I made an app with Sharepoint as the backend. After three months of development, the app is now fully functional and ready according to me. The problem is that the app was built and tested on dummy data. Now that I have real data, which is a lot more than manually entered dummy data, I am trying to find ways to automate data entry into Sharepoint lists from my large excel files. Can somebody please point me in the right direction?

 

Thank you and have a great day!

@RandyHayes 

@Pstork1 

@Jeff_Thorpe 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

Re: Bulk uploading items into a list

@BigTex 

 

within power apps your could load your excel sheet as a datasource, also load your sharepoint lists as a datasource. 

 

Then have a button with the onselect parameter set to something like: 

 

ForAll(EXCELTABLENAME, 

Patch(SHAREPOINTLISTNAME, Defaults(SHAREPOINTLISTNAME), {SPCOL1:EXCELCOL1, SPCOL2:EXCELCOL2}))

There might be ways to do this natively from sharepoint I am unaware of. 

 

Thanks, 

Luke

View solution in original post

3 REPLIES 3
Highlighted
Resolver II
Resolver II

Re: Bulk uploading items into a list

@BigTex 

 

within power apps your could load your excel sheet as a datasource, also load your sharepoint lists as a datasource. 

 

Then have a button with the onselect parameter set to something like: 

 

ForAll(EXCELTABLENAME, 

Patch(SHAREPOINTLISTNAME, Defaults(SHAREPOINTLISTNAME), {SPCOL1:EXCELCOL1, SPCOL2:EXCELCOL2}))

There might be ways to do this natively from sharepoint I am unaware of. 

 

Thanks, 

Luke

View solution in original post

Highlighted
Dual Super User II
Dual Super User II

Re: Bulk uploading items into a list

That's probably as good a way to do it as any.  You could also use Flow or PowerShell.  Doing it natively in SharePoint is possible when creating a new list, but doesn't really work when trying to add data to an existing list.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper I
Helper I

Re: Bulk uploading items into a list

@Luke_Timmins 

 

Thanks a lot! That worked pretty well.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,673)