Forum Discussion
How to migrate from excel to sharepoint list
Murali_krishna_P no, that's not what I said at all. Follow my instructions and enter the threshold as 15000 or whatever the number of rows is. That gets over the 100 row default. Then the flow will bring back all the rows and you can add the apply to each and create item action to add them them into SharePoint. It won't be quick as the flow has to process every row.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
You can also use VBA, code below needs to be modified to loop through your Excel
Sub NewSharePointItem()
'Reference to be added: Microsoft ActiveX Data Objects 6.0 Library
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim SQL As String
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
SQL = "select * from [NIFdb] ;"
With con
.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=https://xyz.sharepoint.com/sites/site/;LIST={81e876da-1d06-4c9f-bc40-177e66b97db6};"
.Open
End With
rs.Open SQL, con, adOpenDynamic, adLockOptimistic
rs.AddNew
rs.Fields("Column1 Name here") = cell(1,1)
rs.Fields("Column2 Name here") = cell(1,2)
rs.Update
rs.Close
If CBool(rs.State And adStateOpen) = True Then rs.Close
Set rs = Nothing
If CBool(con.State And adStateOpen) = True Then con.Close
Set con = Nothing
End Sub