cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BigTex
Level: Powered On

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
Luke_Timmins
Level 8

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
Luke_Timmins
Level 8

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

Dual Super User
Dual Super User

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.
BigTex
Level: Powered On

Re: Bulk uploading items into a list

@Luke_Timmins 

 

Thanks a lot! That worked pretty well.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 221 members 2,352 guests
Please welcome our newest community members: