Solved

Uploading data from SharePoint to Azure Database

  • 15 April 2020
  • 1 reply
  • 6 views

Badge +3

I'd like to query data in a SharePoint List and upload into an Azure Database.

 

Is this possible with Workflow Cloud?

icon

Best answer by butlerj 21 April 2020, 16:51

View original

1 reply

Userlevel 5
Badge +19

@mcamarco Yes this is totally doable. I've included some screenshots for how this can be done below:


 



 


 


 


 


 


 


 


 


 


 


 


 


 


 


First you run your SharePoint query:



 


Then you need to extract the Item ID from the returned collection:



 


If you want a specific value from the list item you can then retrieve that and store it into a variable (such as title):



 


And then you can execute a SQL statement to upload this to your Azure Database:



 



 



 


Hope that helps!

Reply