Forum Discussion
Workflow for importing Excel to List
I'm a novice developing a workflow for importing an Excel spreadsheet to a SharePoint list. Have I missed anything? Workflow: Thoroughly clean up the data in Excel before importing to a list. Cau...
On your #3, if using Power Automate to import the rows (rather than just copying/pasting) you need to change the settings of the List rows present in a table action. By default it will only bring back a maximum 256 rows, so you need to go to settings, turn on the pagination toggle and change the threshold to a number that is more than the number of rows in your excel table.
Rob
Los Gallardos, Spain
Microsoft Power Platform Community Super User
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)