Forum Discussion
Gilbert Okello
Dec 21, 2016Iron Contributor
Updating SharePoint List from Excel
John White, jcgonzalezmartin is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? http://www.softfluent.com/prod...
Alan Marshall
Jan 07, 2019Iron Contributor
I've used Flow to do this before as on selected item in a doc library and scheduled. You can use Get Rows from Excel if you store the file in a doc library or OneDrive and then add a create item in SharePoint. The Excel get rows has a 500 row limit so I used a loop to get batches of 500 and change the start row in the Get Row action based on a variable. You'll need to use a date or flag column in the spreadsheet to track which ones have been done and update it in the loop
Cristen
Oct 21, 2019Copper Contributor
Alan MarshallDo you have a Flow process for updating existing items in a list from Excel?