I'd like to query data in a SharePoint List and upload into an Azure Database.
Is this possible with Workflow Cloud?
Solved
Uploading data from SharePoint to Azure Database
+3Best answer by butlerj
@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!
+20- Nintex Employee
- 260 replies
- Answer
@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!
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.