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? SharePoint List Synchronizer)
Alan Marshall
Jan 07, 2019Steel 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?