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

Display SQL query output in Sharepoint

Hello,  My goal is to capture the data from sql query out put (couple of columns) and display the out put in Sharepoint

I am using the link below to capture the sql query out put to a collection variable using  a worflow

https://community.nintex.com/t5/Nintex-for-SharePoint/Nintex-SQL-query-workflow-action/m-p/9552#M804...

 

How do I display the captured data in Sharepoint list ?

 

Thank you

@R

Labels: (2)
0 Kudos
Reply
3 Replies
brianknight
Nintex Newbie

Re: Display SQL query output in Sharepoint

If it is a site workflow, use Update Item.  If it is a item workflow, use the Set Field Value action.  If you query is pulling multiple columns, you may need to do a build string to pull all your variable items together.  

0 Kudos
Reply
youlearn
Nintex Newbie

Re: Display SQL query output in Sharepoint

This workflow is on a list with a basic form. When user selects a check box1, saves the form then workflow is triggered. 

Can you please give me an example as how I can pull all the output (multiple columns)together. 

0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: Display SQL query output in Sharepoint

Hi,
At the end of solution on the post you linked you are left with collection variables for each column.
If you check out the workflow on the linked post below you will see how to work with two collection variables and pull out what you need and combine it.
https://community.nintex.com/t5/Nintex-for-SharePoint/Split-string-help/m-p/99534/highlight/true#M69...
0 Kudos
Reply