I got this error while trying to move a large amount of data from Excel to SharePoint list. Only 20k or 500k made it through. I was given the following advice (see below). Does anyone here have any comment about the action as it pertains to Power Apps?
My Comment:
I have been asked to combine an existing Excel workbook, with 10 sheet of 60,000 items a piece, into on sheet (which I've done), create a SharePoint List from that single Excel sheet (which I am trying to do), so that new items can be added to the SharePoint list through Power Apps and all the data analyzed and visualized through PowerBI.
I was told, and am under the impression - from my readings, that SharePoint could handle large lists such as this, is that not the case?
What are your recommendations?
His Reply:
I'd highly recommend not trying to add 700K items to a SharePoint List. A SharePoint List can (according to Microsoft) contain up to 30 million items. However, in reality this is definitely not the case. As soon as you get over around 95K items things start to break down. You can't change search settings on the list, can change permissions, can't export list items, etc. And trying to retrieve that many items from SharePoint via Power Apps and Power BI is not going to work.
I would suggest using Dataverse (Table) as the data source instead of SharePoint. This is a lot more robust with that many items and works much better (quicker) with both Power Apps and Power BI.
I'd recommend posting something in the Power Apps or Power BI forums to ask for some advice on best approach specific to your scenario.
