Forum Discussion
FLOW Import Excel Online Rows into SharePoint Custom List
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?...
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 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.
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
Damien_Rosario how to add if my excel has 10k rows?
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
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
