Bring an excel with 40k rows

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey Guys, can you help me please?

I have a excel spreadsheet wich cointains 37k rows and i want to bring it to powerapps.

the data does not change, so i uploaded the excel via import via excel, and when i collect it brings me 15k rows.

but how can i separate in 15k15k and another one with 8k to bring all the datas?

I tried several ways here on the forum using concurrents, collecting ascending and then descending but i guess am doing something wrong.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

I think what you need to do is to split the data in your source Excel spreadsheet so that your 37k rows are separated over 3 tables/worksheets.

You can then import these 3 separate Excel tables and ClearCollect them into a single collection.

ClearCollect(AllRecords,
ExcelTablePart1, ExcelTablePart2,
ExcelTablePart3
)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Nice!

Worked like a charm!

Thanks!
timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Glad that works @Anonymous Hope you win another company prize soon!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @timl , your solution worked, but now when I showed the app they requested me another thing to do that is similar, but different hahaha

I will try to explain:

I have a list with the 37k rows, in a gallery, showing only when filtered by 2 boxes.
The main point of the app is to do some kinds of checklists, search on the excel table and then submit.

I have an unique ID that is the EQUIPMENT, this EQUIPMENT will have many times on sharepoint list (after submitted the checklist).

What I need to do is: On the first gallery, shows an check mark if that EQUIPMENT is already done (search on SP list and mark ok, what I did is count if the Equipment appears more than 1 time on SP list and shows an mark, this is easy), the problem is, I have 37k rows of equipments so if I search the equipment on SP list, one day it will not bring anymore due to rows limit right? even if i collect sp list it only brings me 2k rows...

I thought in collecting the equipments done in a excel DB but if i collect also brings me only 4k rows. maybe i need to split in a lot of tables in this case ;(
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

I think you might be OK here. If within your gallery control you carry out a count of your SharePoint list where the equipment IDs match, that query should be delegable and you might not have any delegation problems. It won't be fast but I think it'll work.

Alternatively, if you want to load your SharePoint list into a collection, you could use this technqiue that @martinav mentioned the other day.

https://powerusers.microsoft.com/t5/General-Discussion/Another-method-for-making-a-collection-from-Sharepoint-and-SQL/m-p/253149#M74217