cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Uploading data from SharePoint to Azure Database

Jump to solution

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

 

Is this possible with Workflow Cloud?

Labels: (1)
0 Kudos
Reply
1 Reply
Highlighted
Community Manager Community Manager
Community Manager

Re: Uploading data from SharePoint to Azure Database

Jump to solution

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

 

Screen Shot 2020-04-21 at 7.44.29 AM.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

First you run your SharePoint query:

Screen Shot 2020-04-21 at 7.44.38 AM.png

 

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

Screen Shot 2020-04-21 at 7.44.44 AM.png

 

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

Screen Shot 2020-04-21 at 7.44.52 AM.png

 

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

Screen Shot 2020-04-21 at 7.46.00 AM.png

 

Screen Shot 2020-04-21 at 7.45.27 AM.png

 

Screen Shot 2020-04-21 at 7.47.24 AM.png

 

Hope that helps!

View solution in original post

0 Kudos
Reply