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
Murali_krishna_P in your list rows present in a table action you need to go to settings, switch on the pagination toggle and set the threshold which is the number of rows to return, for example 15000. If you don't do this the action only gets 100 rows by default.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Thank you for reply.
I want to understand your answer means get 100 recrods first then write only those 100 records, next get another 100 and update repeate correct me if i am wrong.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- Okay thank you.
