Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : v7NIqdPaA4BbAbtk1zuFka
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse Not importin...
Power Apps - Microsoft Dataverse
Unanswered

Dataverse Not importing all rows from sharepoint list

Like (2) ShareShare
ReportReport
Posted on 3 Sep 2024 09:17:46 by pathakanuj30 11
I am creating a new table using option create a new table
(preview) by importing sharepoint list. Sharepoint list has 900+ records but in data verse table it shows only 20 records, however all columns got cretead successfully  but not rows. I have also tried to connect with powerapps and show the data in gallery  to validate but still it only shows 20 records. What could be wrong here ?
Categories:
Microsoft Dataverse
  • PF-03101441-0 Profile Picture
    PF-03101441-0 6 on 07 Oct 2024 at 09:24:49
    Dataverse Not importing all rows from sharepoint list
    I experience the same error when using csv or xlsx files.
  • MickH Profile Picture
    MickH 26 on 09 Sep 2024 at 06:34:52
    Dataverse Not importing all rows from sharepoint list
    I have the same issue trying to import data from a Sharepoint list with several hundred entries.  No matter what I do the table population caps at exactly 20 lines.

    The advice I've found online is variously;
    1. Wait a while, it's a slow process (I've been waiting for months with no further data appearing in my table) or
    2. The data is there but isn't displayed (My learning model isn't being trained because the table's population is under 50, so I'm pretty sure it isn't there).

    I'm not satisfied with either explanation for the bracketed reasons.  I'm hoping MS can come up with a fix.
  • pathakanuj30 Profile Picture
    pathakanuj30 11 on 04 Sep 2024 at 07:43:05
    Dataverse Not importing all rows from sharepoint list
    HI I have created the table first using using option create a new table
    (preview).Then select sharepoint site and list to import the data to table.
  • Shashank Bhide Profile Picture
    Shashank Bhide 934 Super User 2025 Season 1 on 03 Sep 2024 at 15:59:43
    Dataverse Not importing all rows from sharepoint list
    How are you importing the records?? Have you tried dataflows? Not sure how are you using PowerApps to import because PowerApps has delegation issue , though not for 20 records, yet, I'll suggest to see if someone has set the delegation row count as 20. Try to import records using standard data import tools like dataflow or ADF.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,518 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,692 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans