Skip to main content
Nintex Community Menu Bar

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

 

Is this possible with Workflow Cloud?

@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!