Answered

20 rows limit while importing from any data sours

(0) Share

Report

Posted on by PC-16062019-0

Hello

I'm creating a list in SharePoint using the Lists app. The list has 5 columns and 40 rows. Every time I try to import it into Power Apps, I get a table with exactly 20 rows. What's going on? The only place I check this is directly after creating the table in the "view data" option. Are all the rows being imported or just these 20? What am I doing wrong?

Thanks for any help

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (2)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @PC-16062019-0,

How are you importing it into Power Apps ?

Was this reply helpful? Yes No
PC-16062019-0 9 on at

Like (0)

Report

Hi, thanks for response!,

Add data -> Data -> Create new table -> Import an Excel file or .CSV.

Same problem with .xlsx or .csv

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,013 Super User 2025 Season 2 on at

Like (1)

Report

@PC-16062019-0,

Instead of importing the data from Power-apps try to import the data from the sharepoint itself.

Step 1

Navigate to the SharePoint Site -> New -> List

Step 2

Select the Import options accordingly.

Step 3

Choose the column mapping accordingly

I created 5000 records from the excel file without any issues.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
PC-16062019-0 9 on at

Like (0)

Report

great!
thank you!

But my company blocked creating new lists from sharepoint. I needed to use Lists app.

Now works.
Will it be possible to save data to such a list from an application created in Power Apps?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @PC-16062019-0,

Lists is actually SharePoint so yes

Was this reply helpful? Yes No