How to upload a 3,000 row in sharepoint list

[kcpelobello]

Hi guys,

Good day, I'm building an App from PowerApps, and I need to upload the Master list file for my database/sharepoint list.  Can you teach me how to upload a 3,000 data from excel to sharepoint list?

Thank you.

[JatinSaini]

Sure, I can guide you through the process of uploading a Master list file from Excel to a SharePoint list using PowerApps. Before we begin, please ensure you have the necessary permissions to create and modify lists in SharePoint.

Step 1: Prepare your Excel data Make sure your Excel file contains the data you want to upload to the SharePoint list. Ensure that the column headers in Excel match the fields in your SharePoint list to simplify the mapping process.

Step 2: Create a SharePoint list If you haven't already created a SharePoint list, follow these steps:

1. Go to your SharePoint site.
2. Click on "Site Contents" in the left-hand navigation pane.
3. Click "New" and then "List."
4. Choose "Import Spreadsheet" and give your list a name.
5. Upload the Excel file you prepared in Step 1 and follow the prompts to create the list.

Step 3: Create a PowerApp Now, let's create a PowerApp to import data from your Excel file to the SharePoint list:

1. Open PowerApps (https://make.powerapps.com/) and sign in with your Microsoft account.
2. Click on "Create" from the left-hand navigation pane and select "Blank app" under Start with your data.

Step 4: Connect to SharePoint list and Excel file

1. On the PowerApps canvas, click on "Data sources" in the right-hand pane.
2. Click on "Add data source" and select SharePoint. Connect to the SharePoint site where your list is located.
3. Click on "Add data source" again and select "OneDrive for Business" or "SharePoint" depending on where your Excel file is stored.
4. Connect to the appropriate OneDrive or SharePoint location and select the Excel file containing your data.

Step 5: Design the PowerApp

1. On the PowerApps canvas, add a button and a gallery control.
2. Set the gallery's data source to your Excel file's data source.
3. Add the necessary fields to the gallery that match the columns in your Excel file.

Step 6: Create the upload functionality

1. Select the button on the canvas, and in the right-hand pane, click on "Action."

2. Click on "Add a new step" and choose "ForAll" from the functions list.

3. In the formula bar, enter the following formula:

ForAll(YourExcelDataSource, Patch(YourSharePointList, Defaults(YourSharePointList), {Column1: ThisItem.Column1, Column2: ThisItem.Column2, ...}))

Replace "YourExcelDataSource" with the name of your Excel data source in PowerApps and "YourSharePointList" with the name of your SharePoint list.

• Save your app, and it should now be ready to upload data to your SharePoint list.

Step 7: Test the app

1. Go to the "Play" button in the top-right corner of the PowerApps studio to test your app.
2. Click on the button you created to start the data upload process.
3. Your app should start uploading data from the Excel file to the SharePoint list.

Please note that this process may vary slightly depending on the version of PowerApps and SharePoint you are using. Always make sure to thoroughly test your app before performing any mass data uploads to avoid unintended consequences.

[kcpelobello]

Thank you, I will try this.

[kcpelobello]

@JatinSaini hello, do I need to create 2 galleries for 26 columns to match my excel sheet (Step 5, #3)?

[kcpelobello]

It's only 10 columns in one blank Gallery..

[JatinSaini]

Hi @kcpelobello ,

I you have 26 columns or more than that, you can also do one thing. 

Create a new list on the sharepoint using that Excel File Spreadsheet as a data source. Update/Modify the SP List columns matching your requirements. And then import that list on to the powerapps.

[kcpelobello]

Hi @JatinSaini 
I already have existing SharePoint List with exact column in Master List (excel file) that my manager gave me, I just want to upload it to populate the list screen that I created.

[JatinSaini]

Have you already uploaded the Sharepoint List as a datasource and use that under the gallery items property?

[kcpelobello]

Not yet because as you said in Step 5 need to match the columns on the gallery and excel before uploading it to sharepoint list.