Forum Discussion

Copper Contributor

Nov 15, 2023

How can I bulk upload an existing sharepoint list?

Hi there, We have an existing List in a SharePoint site and this List is rather extensive. I need to be able to bulk upload this list via a CSV. Is this achievable? Best regards,

Copper Contributor

Nov 15, 2023

NicolasKheirallah

issue is, that SharePoint page that hosts the list syncs to a sql server. I know that the exact https URL was used to create the API that connects it to the sql server, which is why I have update the existing list in order to prevent cutting that connection.

do you think it’s possible to bulk upload an existing list?

NicolasKheirallah

MVP

Nov 15, 2023

Well that something you should have included from the start 😄

Then I recommend you to use Power Automate and copy over the data you want to copy using a timer trigger or similar depending on your use-case

I'm guessing you want to copy from SQL to a SharePoint list ?

Saadat289
Copper Contributor
Nov 15, 2023
NicolasKheirallah
Indeed I should have.
Other way round actually, the data needs to be extracted to the SQL server as it gets pulled into PowerBi reports from there.

Thanks for the tips. Are there any good PowerAutomate resources you can point me to for doing this?

Best regards,
- NicolasKheirallah
  MVP
  Nov 15, 2023
  Why not get the data directly from the SharePoint list ? might be easier to just add it as a source 🙂
  
  Here's an old blogpost (not mine) that you can followm, the steps are the same more or less:
  
  https://gbamezai.medium.com/power-automate-create-sharepoint-to-sql-data-pipeline-from-a-scratch-65f29e8cceb5