Forum Discussion
FLOW Import Excel Online Rows into SharePoint Custom List
Assuming I understand you right, you may want to try using List rows present in a table and if you have a SharePoint list that already has the relevant columns in it, you can just drop what the spreadsheet has into it.
Excel spreadsheet:
The flow:
and the result:
Hopefully that does the trick for you!
Cheers
Damien
Damien_Rosario how to add if my excel has 10k rows?
Not sure I understand your scenario, but either way you'll need to have those rows as part of a table to be able to retrieve and update from.
I've never done anything with 10k rows so not at all sure how to manage that or even if Power Automate can manage such a large number of them in that way.
Best wishes
Damien
Mark Antony Imperial yes a List rows present in a table action CAN handles 10k rows. But you need to go to the settings for the action, switch the pagination toggle button to On and set the threshold to a number higher than 10000.
Rob
Los GallardosMicrosoft Power Automate Community Super User
