web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / HELP, Please. Surely t...
Power Apps
Unanswered

HELP, Please. Surely there is a way to import an Excel sheet into Sharepoint NEW List.

(0) ShareShare
ReportReport
Posted on by

I have been trying to import an Excel spreadsheet into a new-style Sharepoint list.  The only way I have found that works--sort-of--is the copy/paste method.  I have 15,000 records and I am growing increasingly frustrated.  Am I missing something? I am sure I must be thus my plea for help.  Thank you.

Categories:
  • ThatAPIGuy Profile Picture
    925 on at

    I would recommend connecting the excel spreadsheet(on OneDrive) and the Sharepoint List  as data sources in powerapp and set the OnVisible or OnStart property to ClearCollect(SharepointListName, ExcelTableName)

     

    Not sure about two things -

    1. if it will copy all the 15000 records . you might have to run it in 3 batches of 5000 each

    2. matching of the column names in excel and sharepoint. I am sure I am missing something in the clearcollect statement

     

    I just wanted to give you some ideas that you may test.

     

    You could also export excel table to sharepoint. yes that's possible from within excel however the list will be in the classic sharepoint format.

  • Meneghino Profile Picture
    6,949 on at

    Hi @ChrisChong, I personally think that the method proposed by @ThatAPIGuy may have delegation issues since at most 2000 records will be read by PowerApps.  Also, why use PowerApps when you can import directly?

    Have you tried either of the two methods below?  If so, what are the specific issues that you are encountering with them?

    https://support.office.com/en-us/article/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

    https://support.office.com/en-us/article/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab

  • Meneghino Profile Picture
    6,949 on at

    PS I have just tested the second method and it works like magic.  The only issue is that it does not create an identity/ID autonumber column by default and I do not know how to create one ex-post.  If the ID column is required, then I would suggest to first import the data into a list, then create another new blank list with the correct columns as needed (you will however probably also have the annoying Title column) and then move the data from the old list to the new one with a workflow or using Microsoft Flow.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard