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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create with Excel or ....
Power Apps
Unanswered

Create with Excel or .CSV File only importing first 20 rows

(0) ShareShare
ReportReport
Posted on by 8
I've read a lot of places on the forum where people suggest "waiting some time" because the rows will show up after a long delay. This has proven false. The rows never show up.

While the dataflow option is not too complicated, it is a lot of clicks and could be intimidating for newcomers. I would much prefer to teach citizen devs to use the "Create from Excel or CSV" or "Create from SharePoint" feature to start their Dataverse tables, but I can't do that if it's only going to grab the first 20 rows. That just makes the whole process more convoluted. 

Does this feature actually work or doesn't it? Will it EVER import the entire dataset or is it fundamentally broken? We are using GCC cloud, so I understand some things may be different, but this feature has been around long enough; I would expect it to function as intended ... like it says it does in the docs
 
My other questions is : I have figured out how to get the table in with Data Flow, but I don't really understand Data Flow? My aim to replace the Excel or Sharepoint with Dataverse; I do not want an ongoing connection between the resources. I'd like to understand Data Flow more so I know how to guide users in our org on what to do with the old spreadsheet or list if this is the best alternative.

Steps I am taking 

Power Apps -> Tables -> Create with Excel or .CSV file

Select .CSV File
 
Preview of 20 rows shows as expected. Dialogue box shows correct number of rows (See image)

Edit table properties, Click create

Table appears in custom tables but only first 20 rows. Remaining rows are MIA after waiting sometimes for DAYS. 


I have the same question (0)
  • Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at
     
    Try below steps
     
    1. Navigate to your environment
    2. Click Gear icon on the TOP
    3. Click Advance Settings
    4. Click Data Management
    5. Select Imports and See the Log file there to understand the issue.
     
    Please mark as answer if my suggestion helps.
    Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991
  • GoldenNightingale147 Profile Picture
    8 on at
    Hi @Ram Prakash,

    Thank you for these steps. I was able to find the import logs (yay! I've been wondering where they were.)

    Unfortunately, an import log is not created when I use the "Create with Excel or .CSV file" feature. The only log I see is from where I imported data from a model driven app,  but I am trying to use this feature (below). Again, we are on the government cloud subscription, so it's possible this is different behavior than the commercial version.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard