FLOW Import Excel Online Rows into SharePoint Custom List

Question

Since the Excel Connector has been deprecated in FLOW, there is no action "Get Rows" anymore.

What would be the best way to parse every row in an Excel Online (Business) file into a SP Custom List?

I know a new feature is being released this month in SP, where you can create a list from Excel, but this is a manual action, and I need an easy automated way, using FLOW.

any help would be welcome.

damien_rosario · Answer

Hi&nbsp;Mark Antony Imperial&nbsp;&nbsp;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.&nbsp;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.&nbsp;Best wishesDamien

robelliott · Answer

Mark Antony Imperial&nbsp;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.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User

robelliott · Answer

PrasadRedkar&nbsp;you need to have an extra column in your spreadsheet, perhaps called Imported, and for all the rows that have already been imported into SharePoint that item needs to have Yes in it.&nbsp;Next, the trigger in your flow will be a Recurrence Schedule set to 1 hour.&nbsp;Then your list rows present in a table action should have a filter query of Imported ne 'Yes'&nbsp;so it will only take action on those rows not already uploaded to SharePoint.&nbsp;After the Apply to each and the SharePoint Create item actions, still inside the apply to each you'll need an Excel for Business action to update the row in the a spreadsheet with Yes in the Imported column.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User

damien_rosario · Answer

Hi&nbsp;Stefaan De Vreese&nbsp;&nbsp;Assuming I understand you right, you may want to try using List rows present in a table&nbsp;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.&nbsp;Excel spreadsheet:&nbsp;&nbsp;The flow:&nbsp;&nbsp;and the result:&nbsp;&nbsp;&nbsp;Hopefully that does the trick for you!&nbsp;CheersDamien

mark antony imperial · Answer

Damien_Rosario&nbsp;how to add if my excel has 10k rows?

Forum Discussion

FLOW Import Excel Online Rows into SharePoint Custom List

Share

Resources