Forum Discussion

Murali_krishna_P's avatar
Murali_krishna_P
Copper Contributor
Feb 22, 2022
Solved

How to migrate from excel to sharepoint list

Hi Team,   we have an excell around 15k records, we have tried to update using Power automate, but after writing 100 records its not perfomring any, seems like limitation.   Is there any way to u...
  • RobElliott's avatar
    RobElliott
    Feb 22, 2022

    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

Resources