FLOW Import Excel Online Rows into SharePoint Custom List

[Stefaan De Vreese]

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.

[#2]

Hi @Stefaan De Vreese 

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

[#3]

@Damien_Rosario how to add if my excel has 10k rows?

[#4]

Hi @Mark Antony Imperial 

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

[#5]

@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 Gallardos

Microsoft Power Automate Community Super User

[#6]

@Damien_Rosario The pulling of data was great but if want to pull live data every one hour it pull same data again and again and every time duplicate date is generated. pls help.

[#7]

@PrasadRedkar 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.

Next, the trigger in your flow will be a Recurrence Schedule set to 1 hour.

Then your list rows present in a table action should have a filter query of Imported ne 'Yes' so it will only take action on those rows not already uploaded to SharePoint.

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.

Rob
Los Gallardos
Microsoft Power Automate Community Super User