Easiest way to convert 20,000-record Excel File to SharePoint List

[geraldmpiper]

I'll need a data source to use to lookup & verify a record with a unique 9-digit ID. Is there an easy way to convert my 20,000-record Excel file to a SharePoint list, or can I leave the Excel file as is and use it for the lookup?

[geraldmpiper]

Drrickyp -

Thanks again for your solution involving static data - it's working great, except that I seem to be running into a 15,000 record limitation with my Excel table. The app can't locate any records past 15,000 - Looking up record 15001 comes up blank. I've checked the table in Excel, and deleted and reconnected the static table, but I keep running into the same problem. Can't locate any documentation on this particular limitation - any suggestions? Thanks.

[Drrickryp]

@geraldmpiper,

I tried on my end and you are correct.  The maximum number of records imported from a static data source is 15000, and as you said, there is no documentation regarding this limitation.  At this point, I don't see an alternative while using the Static data method other than splitting the file into one 15000 row table and then another table for the rest of the data, importing both tables into PA, searching them individually, creating two collections and then combining the results. Not a very elegant solution.  Perhaps @mr-dang can help.  

[geraldmpiper]

Thanks so much for your quick reply!

[Drrickryp]

Hi @geraldmpiper,

I actually tried what I suggested using the US postal code table.  It has just over 42000 rows.  I split it into three separate tables of no more than 15000 rows and imported all three into Powerapps.

I set up a button, a textinput control and a datatable control. The code on the button was 

Concurrent(ClearCollect(srch,Search(Table1,TextSearchBox1.Text,"City")),ClearCollect(srch2,Search(Table2,TextSearchBox1.Text,"City")),ClearCollect(srch3,Search(Table3,TextSearchBox1.Text,"City")));Collect(srch,srch2);ClearCollect(all,srch3,srch)

The Items property on the datatable was srch and...

No joke, it really did!

[geraldmpiper]

Thanks again, Drrickyp! I'm now completely overwhelmed, but it's not a bad feeling!

[CMSGuy]

I know this is years old, but still this answer just saved me a big headache.  I was trying to recreate the wheel and import a spreadsheet with almost 80K records

[matthew_keough]

This is the true answer, modern sharepoint online excel import detects 20K records and cancels the upload. I just imported 23K using this method, it's how I used to do it.. and apparently still have to.